Share a Split Microsoft Access Database Across Multiple Computers
Question details
Set up a split Microsoft Access database so multiple computers can use the same back end at the same time.

- 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.
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.
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.
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.
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.
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.
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.
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.
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.

Restore access to the shared network folder
Use this solution if the other computers cannot find or open the folder hosting the Access back end.
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.

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.




