Can Microsoft Access Use OneDrive for a Split Database Backend?
Question details
Determine whether a split Microsoft Access database can use a regular OneDrive folder for its shared backend.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Multiple users need reliable access to backend tables from separate Access front ends.
- Observed behavior
- The goal is a shared backend that supports concurrent access without relying on OneDrive file synchronization.
Identify where the backend tables are currently stored and whether users connect over a reliable local network or need remote access. Confirm that each user has a separate local copy of the Access front end.
Use Azure SQL Database as the Shared Backend
Use a server-based database when users need concurrent or remote access to shared data.
Move the backend tables to Azure SQL Database, then link them to each Access front end through ODBC. This requires database configuration, suitable permissions, and network access to the server.
In the Azure portal, create an Azure SQL Database and configure access for the users or network that will connect to it.
Use SQL Server Migration Assistant for Access or another suitable migration tool to move the Access backend tables and data to Azure SQL Database.
In the Access front end, select External Data > New Data Source > From Other Sources > ODBC Database, choose to link to the data source, and connect to the SQL database using an appropriate ODBC driver or data source.
Open separate local front-end copies on two users' computers and test reading and updating records in the linked tables.

Store the Access Backend on a Dedicated File Server
Use a shared file server when users have a reliable local network and want to retain an Access backend file.
Work With Office Files Using WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and compatibility with common Microsoft Office formats, making it easy to move everyday documents, spreadsheets, and presentations. It does not replace an Access backend or fix Access database sharing.

Frequently Asked Questions
Why shouldn't I put the shared Access backend in a OneDrive folder?
A regular OneDrive folder synchronizes local file copies rather than providing the shared file access Access expects. Concurrent changes can cause sync conflicts or inconsistent data.
Can each user keep an Access front end on their own computer?
Yes. Give each user a separate local front-end copy and link its tables to the shared backend using Linked Table Manager or an ODBC connection.
Can SharePoint replace the backend tables?
SharePoint lists can be an option for some applications. In Access, use External Data > New Data Source > From Online Services > SharePoint List to link lists, and test whether their features and limits suit the application. A synchronized SharePoint document library is not the same as using SharePoint lists.
Does WPS Office fix an Access backend stored in OneDrive?
No. WPS Office does not fix Microsoft Access database synchronization or replace an Access backend. Use a supported database server or a reliable shared file server for the Access data.




