Forum Discussion
Migrating Access back end to the cloud
- Do you want to run this relational database application as a web - browser based application, or as a desktop application?
I don't know which "guys in India" you mean, or what they recommend, but you really don't need a lot of other software packages if you are going to continue to use this as a desktop application. However, if you want to replace the Access interface with one that will operate in a web browser, you WILL have to invest in and learn to use the appropriate tools for that.
So, start by explaining who will actually use it, where they are physically located (in a single facility or dispersed among several) and how you anticipate using this relational database application. From there, we can examine some options.
I found one method that works but there is a caveat to be aware of, that is by syncing the SharePoint library to OneDrive you can link the front end to the back end in the windows folder structure for the SharePoint library that is being synced via OneDrive. The caveat is I have not done testing with multiple user input scenario with the delay of OneDrive syncing the backend to the actual cloud location.
The use of the export to SharePoint function in Access 365 works well and makes library of lists with the data from the tables in it, the tables in Access become a link to SharePoint, you have to have a properly structured database, or you will get errors when moving data to SharePoint, there is plenty of docs on the web that show you how to do this.
Don't forget to always backup 1st...
Regards... Matt
