troubleshooting Question

What are my options to share data with field staff

Avatar of Rob4077
Rob4077Flag for Australia asked on
Microsoft SharePointMicrosoft AccessAzure* powerapps
25 Comments4 Solutions251 ViewsLast Modified:
I have a need to make a small subset of data, currently stored on a MS Access database, available to field staff. I can fit the data on a single table of about 20 fields and a maximum of 500 records. I don't want staff to add or delete records and I am happy for data updates to come back to us via email. It would be nice if they could also return photos with the email but that's not imperative. Realistically the interactivity requirements will increase over time but not too much as my users are not tech-savvy.

So far have been looking at PowerApps as a possible solution. However I have found that a PowerApp connected to an SQL Azure backend only has an effective 1 year lifespan before MS withdraw that option. I tried looking at a SharePoint List as a backend but it is unreliable and therefore unworkable. So I am after some suggestions for alternative approaches that are not going to cost a fortune, are going to be relatively easy to integrate with MS Access and will not force me into months of learning a new language.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 4 Answers and 25 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 25 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros