File Sharing Problems

Share a Split Microsoft Access Database Across Multiple Computers

Ayan MasoodAyan Masood Nov 14, 2026 868 views

Question details

Set up a split Microsoft Access database so multiple computers can use the same back end at the same time.

Share a Split Microsoft Access Database Across Multiple Computers
Product
Microsoft Access
Device & OS
not provided
Scenario
The database works on one computer, but other computers need simultaneous access after the back end was moved to OneDrive.
Observed behavior
The copied front ends display macro and spelling errors before the switchboard opens.
Before you start

Ask all users to close the database before moving the back end. Identify the back-end file and check that every computer can reach a shared network folder that is not synchronized by OneDrive.

Solution 1Recommended

Move the Access back end to a shared network folder and relink the front ends

Use this setup to give multiple computers simultaneous access to one back-end database while keeping each front end local.

1
Find the current back end

Open the front end in Access and select External Data > Linked Table Manager. Check the linked tables and their data source location to identify the back-end file.

2
Create and test a network share

On the computer hosting the back end, share a folder on the local network. Give every database user permission to create, read, modify, and delete files in the folder, and verify that each computer can open it using a network path such as \\HostComputer\DatabaseShare.

3
Move the back-end file

With all users out of the database, move the back-end file from OneDrive to the shared network folder. Do not use a cloud-synchronization folder for the shared Access back end.

4
Relink the tables

Open a local front end in Access and select External Data > Linked Table Manager. Select the linked tables, choose the option to relink or change their data source, and browse to the back-end file using the shared network path.

5
Deploy local front ends

Copy the relinked front-end file to a local folder on each computer. Open each local copy and confirm that its linked tables and switchboard work.

6
Trust the front-end folder

On each computer, open Access and go to File > Options > Trust Center > Trust Center Settings > Trusted Locations. Add the local front-end folder only if you trust the database and the folder is protected from untrusted changes.

Move the Access back end to a shared network folder and relink the front ends
Test simultaneous access: Have two users open their own local front ends and test the database at the same time. If errors remain, investigate the specific macro or spelling error separately; relinking may not fix unrelated application issues.
Free Microsoft Office alternative

Use WPS Office for Everyday Documents and Spreadsheets

WPS Office is a free, lightweight alternative for common Office tasks. Its familiar interface and Microsoft Office format support make it easy to move documents and spreadsheets between suites. It does not replace or repair a multi-user Access database.

Open and edit Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTXUse a familiar interface for everyday document and spreadsheet workWork with shared spreadsheets for suitable non-database tasksKeep a lightweight office suite available alongside Microsoft Access
microsoft office alternative - wps office

Frequently Asked Questions

Can I put the shared Access back end in OneDrive?

Do not use OneDrive or another cloud-synchronization folder as the back end for simultaneous Access users. Place the back end in a shared network folder instead and relink each front end to that location.

How do I find the back-end file used by my front end?

In Access, open External Data > Linked Table Manager and inspect the linked tables and their data source location. You can also review a linked table's connection properties.

Why does each user need a local front-end copy?

A separate local front end lets each user run the forms, queries, and code from their own copy while all users connect to the same shared back-end tables.

What permissions do users need on the shared folder?

Users need permission to create, read, modify, and delete files in the folder. Check both Sharing and Security permissions in the folder's Properties on the host computer.

What should I do if errors continue after relinking?

Confirm that every linked table points to the network back end and that the local front-end folder is a trusted location. Then investigate the specific macro or spelling error, because it may have a separate cause.