Forum Discussion
Moving Away from MS Access
I am replying as a longtime Access developer, DBA and vendor.
1) Firstly, you need to migrate your data and structure to a SQL server of your choice. The natural choice for most Access developers is SQL Server. It is important to make a concerted effort to clean up your database structure as you migrate.
This goes a long way towards helping you slip off the Golden Handcuffs that Microsoft Access sometimes feels like. You can now run your Access application in parallel to any other solutions and properly compare the results.
In addition, this allows you to centralize your data (No more data Silo) and virtually eliminate any corruption issues.
2) Secondly, you need to take a clear look at the problem you are trying to solve. There is a mind-boggling array of tools available. None of them is a perfect match for Microsoft Access, but many can solve specific problems much better than Microsoft Access.
Finally, as a vendor, I would like to suggest that you look at https://dbfront.com/alternative-to-msaccess. With dbFront, you can quickly create powerful web applications based on your existing databases. dbFront applications have a deep knowledge of the underlying data and structure and know how to show the data in context.