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.
<<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.>>
Think he meant Access Web apps there...Power Apps are certainly not going away in a year.
and I would agree; www.eqldata.com is probably the best bet at the moment.
Jim.