Adding the Backend Access database to SharePoint

Question

Hi,

I work in a small company that will be moving to some remote working in the near future. I developed an Access database a few years ago which is a split database with multiple (at most 5 at one time) front end users and the back end stored on our Network server. With moving to remote working I'm looking into moving the back end of the database to SharePoint so we will be able to use it from remote locations and this seems to be the best fit for our company. I've run some tests which are inconclusive as to the best way to do this move without risking the ability to access the tables in the back end, if needed for future development, and also allowing front end users the same functionality as before.

Please can you confirm the best way to do this move? ... Is it as simple as physically moving the back end files to the SharePoint location within files and relinking them or is it a more complex process?

Many thanks

Answer 1

You can migrate the tables from the back end accdb to SharePoint lists.

That is the only way to put the Access back end "on SharePoint" for shared use by multiple users. Not the accdb, only the data migrated to SharePoint lists.

Here's an excellent presentation on doing this, with all of the steps to do so and some caveats.

https://youtu.be/Uw6JBJfcjCo?si=F8a7UiMSoNEwFz1k