Can You Share a Microsoft Access Database Through OneDrive?
Question details
The user wants to know if it is possible to share a live Microsoft Access database using a shared OneDrive folder for multi-user collaboration.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Multiple users need to access, edit, and collaborate on the same Microsoft Access database simultaneously.
- Observed behavior
- OneDrive synchronizes entire files rather than record-level changes, resulting in synchronization conflicts and multiple duplicate copies instead of a seamless shared database environment.
Before attempting to change how your database is shared or split, always create a localized backup copy of your original .accdb file to prevent accidental data loss or corruption.
Split the Access Database for Local Network Sharing
Because OneDrive cannot host a live database, the safest approach for multi-user sharing is splitting the Access database into a front end and back end over a reliable local network.
OneDrive is not designed to host a live, shared Access database. Its synchronization mechanism handles whole files, which inevitably creates conflicting copies when multiple users make edits at the same time.
To allow multiple users to edit safely, you must split the database. This separates the tables (the back end) from the forms, reports, and queries (the front end), allowing users to access the central data simultaneously.
Open the Microsoft Access database you wish to share. Navigate to the 'Database Tools' tab on the ribbon.
In the 'Move Data' group, click on the 'Access Database' button to launch the Database Splitter Wizard.
Click 'Split Database'. Choose a reliable, shared network folder (do not use OneDrive) to save the back-end database containing your data tables, and click 'Split'.
Once the process is complete, distribute a copy of the new front-end database (the file containing forms and queries) to each individual user's local computer.

Manage and Share Data Easily with WPS Office
If setting up a complex network for a split Access database is too difficult, consider using WPS Spreadsheet for simple, collaborative data tracking. WPS Office is a free, lightweight alternative that fully supports Microsoft Excel formats and offers seamless real-time cloud collaboration.
- 1. Download WPS Office: Visit the official WPS website to download and install WPS Office for free.
- 2. Import Your Data: Export your simple Access tables to Excel format, then open them seamlessly in WPS Spreadsheet.
- 3. Share and Collaborate: Save your spreadsheet to WPS Cloud and use the 'Share' button to invite colleagues to view and edit the data simultaneously.

Frequently Asked Questions
Why does OneDrive create conflicting copies of my Access database?
OneDrive synchronizes entire files rather than merging specific data records. When multiple users open and modify an Access database simultaneously via OneDrive, the system cannot reconcile the individual changes, leading it to create separate, conflicting copies for each user.
Can I use SharePoint instead of OneDrive to share an Access database?
While modern SharePoint no longer supports hosting a live Access web database, you can migrate your Access tables to SharePoint Lists. You can then link those lists to your Access front-end, allowing multiple users to collaborate over the internet safely.
Is there an easier way for a novice to share data without splitting an Access database?
If your database structure is simple and doesn't rely on complex relational tables, the easiest alternative is to export your data to a collaborative spreadsheet format (like Excel or WPS Spreadsheet). Spreadsheets natively support real-time co-authoring via cloud services without requiring split architecture.




