Prevent Duplicate Microsoft Access Databases in OneDrive and SharePoint
Question details
Prevent duplicate database files and synchronization conflicts when multiple users work in Microsoft Access.

- Product
- Microsoft Access, OneDrive, and SharePoint
- Device & OS
- not provided
- Scenario
- Multiple users need to enter data in a shared Access database without cloud synchronization conflicts.
- Observed behavior
- Opening and saving a live database from a cloud-synchronized location can create duplicate files with a computer name appended.
Ask all users to close the database, and identify the current database file and any conflict copies. Arrange a reliable network share where users can read, write, create, and delete files.
Split the Access database and use local front ends
Use this setup for multiple users to reduce cloud synchronization conflicts and the risk of database corruption.
A split database keeps shared tables in a back-end file on a network share and gives each user a separate local front end containing linked tables and interface objects. Do not run either live file from OneDrive, SharePoint, Dropbox, or another cloud-synchronized folder.
In the database folder, identify files with appended computer names and determine which contain needed changes before choosing the database to split. Do not assume the copies were merged automatically.
With all users signed out, copy the chosen database to a local folder outside OneDrive, SharePoint, Dropbox, and other synchronized folders.
Open the local database in Access, then select Database Tools > Access Database and follow the Database Splitter wizard to create the back-end file.
Move the back-end file to the reliable network share, then use Database Tools > Linked Table Manager in the front end to update the linked tables to that location.
Copy the front-end file to a separate local, non-synchronized folder for each user. Have each person open their own copy and confirm that the linked tables work.

Use WPS Office for documents alongside your Access database
WPS Office is a free, lightweight alternative for everyday documents, spreadsheets, and presentations. Its familiar interface and Microsoft Office format compatibility make migration straightforward. It does not replace Microsoft Access or fix Access database synchronization.

Frequently Asked Questions
Why does Access create a copy with my computer name?
A cloud sync service may create a conflict copy when it cannot reconcile changes to the database file. Stop opening the live database from the synchronized folder and inspect the copies before deciding which data to keep.
Can multiple users open the same Access database from OneDrive?
Avoid using OneDrive or another synchronized folder to run a live multiuser Access database. Instead, place the back end on a reliable network share and give each user a local front end.
Where is the Access database splitting tool?
Open the database in Access and select Database Tools > Access Database. Follow the Database Splitter wizard to create a separate back-end file containing the tables.
Can I use OneDrive to store a closed Access database copy?
You can store a copy after all users have closed the database, but do not use the synchronized copy as the live database. Clearly identify the copy so users do not open it instead of the working database.
Does WPS Office open or repair Access databases?
WPS Office is intended for documents, spreadsheets, and presentations; it does not replace Access or repair Access database sync conflicts. Use Access to manage the database and its linked tables.




