Moving Away from MS Access

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.