File Sharing Problems

How to Correctly Split and Share an Access Database for Multiple Users

Olivia Miller Oct 9, 2026 871 views

Question details

Users need to allow multiple people to edit an Access database simultaneously without creating conflicting file versions.

How to Correctly Split and Share an Access Database for Multiple Users

Product: Microsoft Access
Device & OS: Windows 11
Scenario: Two users are attempting to simultaneously edit a shared Microsoft Access database that has been split and hosted on a OneDrive cloud synchronization folder.
Observed behavior: Hosting the shared Access database on OneDrive results in conflicting versions because cloud file synchronization services overwrite whole files and do not support Access record-level locking.

Before you start

Ensure all users are connected to the same local area network (LAN) and create a safe backup copy of your original Access database file before attempting to split it.

Solution 1Recommended

Host the Split Database on a Local Wired Network Share

To prevent conflicting file versions, avoid using cloud sync folders like OneDrive or Dropbox, and instead host the back end of the database on a standard local network share.

Cloud file-synchronization services are designed to transfer whole files when changes are detected. Because Microsoft Access relies on record-level locking to allow multiple users to edit data simultaneously, cloud syncing breaks this mechanism, resulting in conflicted copies and potential data corruption. The correct method is to split the database and host the back end on a reliable, local wired network.

Split the Access database

Open your Access database, navigate to the 'Database Tools' tab, and click on 'Access Database' under the Move Data group. Follow the Database Splitter Wizard to separate your file into a back end (containing tables) and a front end (containing queries, forms, and reports).

Create a local network share

On a host computer or local server that is always on during working hours, create a new folder. Right-click the folder, select 'Properties', navigate to the 'Sharing' tab, and share it with Read/Write permissions for all intended database users.

Move the back-end file

Move the newly created back-end file (usually ending in _be.accdb) into the network shared folder you just created.

Distribute the front-end file

Copy the front-end file to the local hard drive (e.g., Desktop or Documents) of every user's computer. Do not run the front end directly from the network share.

Link the tables

Have each user open their local front-end copy. If prompted to update links, or by navigating to 'External Data' > 'Linked Table Manager', map the tables to the new network path of the back-end file.

Host the Split Database on a Local Wired Network Share

Network Connection Recommendation: For maximum stability and to prevent database corruption, connect the host and all user computers to your network router or switch using wired Ethernet cables rather than Wi-Fi.

Free Microsoft Office alternative

Simplify Data Management with WPS Office

Microsoft Access requires complex networking for multi-user collaboration. If you are struggling with database sync conflicts and only need to manage structured data, switching to cloud-collaborative spreadsheets is often a better solution. WPS Office provides a powerful, free alternative to Microsoft Office, allowing real-time co-authoring without the risk of conflicted copies.

1. Download and install WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your Windows 11 device.
2. Import your tabular data: Export your simple Access tables to Excel format (.xlsx) and open them in WPS Spreadsheet.
3. Collaborate in real-time: Upload the file to WPS Cloud and use the built-in sharing features to invite team members to edit the document simultaneously.

Free, lightweight, and easy to install on Windows, macOS, and Linux devices.Excellent format compatibility with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) files.Built-in cloud collaboration allows multiple users to edit the same spreadsheet simultaneously without sync conflicts.Familiar and highly intuitive user interface ensures a seamless migration from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Access database create conflicting copies on OneDrive?

OneDrive and similar cloud sync services manage files by synchronizing the entire file whenever a change is detected. Since they do not support the internal record-level locking required by Microsoft Access for multiple simultaneous users, the service creates separate, conflicted versions to prevent overwriting someone else's work.

Can I use Wi-Fi to share a split Access database?

While it is technically possible, using Wi-Fi for an Access back end is highly discouraged. Minor interruptions or latency spikes in wireless connections can easily cause database corruption during read/write operations. A wired Ethernet connection is strongly recommended.

Is splitting an Access database ineffective if it only contains tables?

Splitting a database that only contains tables is just the first step. To effectively use a split database in a multi-user environment, you must also build forms, queries, and reports in the front end. If users interact directly with raw tables, they risk locking whole tables rather than individual records, which defeats the purpose of splitting.

Can I use a cloud database service instead of a local network for multi-user Access?

Yes. You can migrate your Access back end (the tables) to a genuine cloud database service like Microsoft Azure SQL or SQL Server Express. This safely allows remote and multi-user access over the internet, but it requires different migration steps than simply sharing a standalone Access file.

Document & File Issues