Forum Discussion
Moving Away from MS Access
Brian_Hayes I feel your pain Brian. I also agree with your comments about all the negativity and asking for more details on what it is you want. My company uses Access very heavily, with a fairly complex Access front end that was built in house over many years, and we'd like to move away from it towards a more cloud based front end. We already us SQL Server as the back end, so enabling users to have more flexibility and the ability to us a front end that doesn't require them to remotely connected to their work computers would be helpful. We have a number of SQL Databases that we connect to and use, trying to maintain all those with an acceptable response time over a VPN via Access proved to be less than idea.
As someone else mentioned we are looking at PowerApps and I just some time looking at the Microsoft Build conference to see what the have going on there, which is a lot. But as I mentioned and maybe is your case too, we have a fairly complex front end, to have to rewrite it from scratch would be time intensive to say the least. Some way to convert it would be ideal. At least then we could have something up and running in less time.
CJ_Butcher I have to say this is one of the best forum discussions I've ever read on this never ending question; how do we get away from Access. I appreciated every response immensely. I am constantly perplexed at how often businesses are unsatisfied with Access. Even with telling them how hard it is to get off of Access, they are all in denial and just want an app from the Apple/Microsoft store that does everything for them. I think it's a combination of it being a Microsoft app, that its VBA based, and that it has limitations that invites the criticality. If something this magical has limitations it just creates suspicions for some reason.
I have decided to keep the many Access front ends we have (which took over 10 years to develop) and move to SQL Server backend. Because they are linked tables its no different to the user as well as the forms. We'll be implementing PBI and SSRS eventually... and thats ok! No two businesses are the same. Just be patient. Microsoft wants all businesses to succeed and they make incredible things. Upgrading our network infrastructure fixed all of our corrupt Access files, so you may want to get that checked out. I hope you find something that works for you.
As an Access developer from it's first version, I have to agree. Moving the backend to MS SQL Server solved all problems with mdb corruption and it is now very fast. VBA is a great environment IMO, and Access makes a great front end that is easily customized. My only wish is that they would provide some sort of iOS application that could import some basic MS Access forms and have an ODBC connection to SQL included in that import.
