Forum Discussion
Sharing and updating an ACCESS database on the cloud
OneDrive is NOT an option. There are technical reasons for that, which you can learn more about here and elsewhere.
Access runs on the desktop, under Windows. The interface elements, including forms, reports and code, must, therefore, be on a Windows computer, not in the cloud.
The data, however, can be uploaded to a cloud location. You have a number of options, including SQL Azure or a hosted SQL Server database, other cloud hosted database engines, and even SharePoint lists.
To deploy your relational database application this way, you start by splitting the interface objects from the data in the tables. That allows you to connect the interface--which we typically refer to as the "Front End"-- to the tables regardless of where they are and which database you choose.
Each of your users must have their own copy of the Front End; it should be on their computers. This is critical in order to avoid, or at least minimize, corruption that can result from trying to share a Front End.
There are other approaches, such as a Remote Desktop deployment in which you place the Back End--the tables with the data--on a shared network location and allow users to remotely connect to it. This is a whole topic of discussion, so if you want to explore this option, you'll need to do your due diligence.
All good if you use SharePoint as a business of course!