File Sharing Problems

Prevent Duplicate Microsoft Access Databases in OneDrive and SharePoint

Anum MushtaqAnum Mushtaq Nov 22, 2026 869 views

Question details

Prevent duplicate database files and synchronization conflicts when multiple users work in Microsoft Access.

Prevent Duplicate Microsoft Access Databases in OneDrive and SharePoint
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.
Before you start

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.

Solution 1Recommended

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.

1
Review conflict copies

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.

2
Move the database out of cloud sync

With all users signed out, copy the chosen database to a local folder outside OneDrive, SharePoint, Dropbox, and other synchronized folders.

3
Split the database

Open the local database in Access, then select Database Tools > Access Database and follow the Database Splitter wizard to create the back-end file.

4
Place the back end on the network

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.

5
Give each user a local front end

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.

Split the Access database and use local front ends
Check network permissions: Users need appropriate permissions on the shared folder so Access can create and remove its locking file. A reliable network is important; splitting reduces risk but does not guarantee against corruption.
Free Microsoft Office alternative

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.

Create and edit documents, spreadsheets, and presentations in a familiar interface.Open and save common Microsoft Office formats, including DOCX, XLSX, and PPTX.Use a free, lightweight suite alongside your Access database workflow.
microsoft office alternative - wps office

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.