Others

Can Microsoft Access Use OneDrive for a Split Database Backend?

Ayan MasoodAyan Masood Nov 20, 2026 869 views

Question details

Determine whether a split Microsoft Access database can use a regular OneDrive folder for its shared backend.

Can Microsoft Access Use OneDrive for a Split Database 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.
Before you start

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.

Solution 1Recommended

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.

1
Create the database

In the Azure portal, create an Azure SQL Database and configure access for the users or network that will connect to it.

2
Migrate the tables

Use SQL Server Migration Assistant for Access or another suitable migration tool to move the Access backend tables and data to Azure SQL Database.

3
Link the tables

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.

4
Test shared access

Open separate local front-end copies on two users' computers and test reading and updating records in the linked tables.

Use Azure SQL Database as the Shared Backend
Check application behavior: After migration, test queries, forms, and update behavior; some Access features or queries may need changes for a SQL backend.
Free Microsoft Office alternative

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.

Use spreadsheets for suitable non-database data tasks.Open and edit common Microsoft Office formats, including DOCX, XLSX, and PPTX.Work in a familiar interface that makes migration easier.Use a free, lightweight office suite for everyday files.
microsoft office alternative - wps office

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.