Forum Discussion

Brian_Hayes's avatar
Brian_Hayes
Brass Contributor
Feb 25, 2020

Moving Away from MS Access

The organization I work for is wanting to move away from Microsoft Access databases where possible, and we have started exploring what tools our current Access databases could be moved to.  Is there ...
admin
developer
office 365
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Jul 08, 2021

CJ_Butcher 

 

Although I was initially luke-warm on PowerApps (at the time they were being introduced, I had just co-authored a book on Access Web Apps for Access 2013, alas). However, I was recently induced to take another look at the current state of PowerApp development. It's now possible to implement a really useful Front End for your relational database applications IF they have a non-Access Back End. In other words, if your BE is in SharePoint, SQL Server/SQL Azure, or one of the other supported data sources (lamentably not accdbs) you can have the best of both worlds, a robust desktop FE in Access and a competent mobile interface running on a smart phone, a tablet, or in a browser. 

I've only done two such PA apps so far, but I'm suitably impressed.

Fatire's avatar
Fatire
Copper Contributor
Jul 08, 2021
Now I’m interested. Haven’t ever made a power app. We have a lot of financial data that is very sensitive and so we do not use the cloud. Can you use PowerApps with a SQL Server in house?

Resources