File Sharing Problems

Use a Microsoft Access Split Database with a Cloud Back End

Steven ParkerSteven Parker Nov 14, 2026 868 views

Question details

The user needs a reliable way to share the back end of a split Access database, including an option for cloud-hosted data.

Use a Microsoft Access Split Database with a Cloud Back End
Product
Microsoft Access
Device & OS
not provided
Scenario
Multiple users need to access shared tables from separate Access front ends.
Observed behavior
A cloud-synchronized folder may create separate local copies, fail to support Access locking, or produce conflicting files when users save changes.
Before you start

Identify the back-end database file and confirm how each front end currently links to its tables. Decide whether users can reach a shared local network server or need a hosted database for remote access.

Solution 1Recommended

Store the Access Back End on a Local Network File Server

Use a shared network folder when all users can reliably connect to the same file server.

1
Set up a shared folder

On the file server, create a shared folder and give database users permission to read, write, create, and delete files in it so Access can manage its lock file.

2
Place the back end on the server

Move the back-end .accdb file to the shared folder. Use the shared network path rather than a cloud-synchronized folder.

3
Update the table links

Open each user's Access front end and go to External Data > Linked Table Manager. Select the linked tables and update their source to the back-end file's network path.

4
Test shared access

Open the front ends on two user computers and test reading and editing data. Confirm that users can connect to the same back-end file without lock or permission errors.

Store the Access Back End on a Local Network File Server
Keep front ends separate: Give each user a separate local copy of the front end; only the back-end tables should be shared on the server.
Free Microsoft Office alternative

Work with Office Files Using WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface and compatibility with common Microsoft Office formats, making it easy to move everyday document and spreadsheet work. It does not replace Access or host an Access database back end.

Open and edit Microsoft Excel .xlsx spreadsheetsWork with Word .docx and PowerPoint .pptx filesUse a familiar interface for everyday Office tasksReview spreadsheet exports of database data without changing the Access back end
microsoft office alternative - wps office

Frequently Asked Questions

Can I put the Access back end in a cloud-synchronized folder?

Do not use a synchronized folder as a shared back end. Sync services may create local copies or conflict files and may not support the locking Access needs. Use a shared network server or a hosted database instead.

What permissions do users need on the network folder?

Users need permission to read, write, create, and delete files in the shared folder so Access can open the back end and manage its lock file. Configure these permissions on the file server.

How do I reconnect Access front ends after moving the back end?

In each front end, open External Data > Linked Table Manager, select the linked tables, and update their source to the new shared network path.

Can Access connect to Azure SQL Database?

Yes. After migrating the tables and configuring access, use External Data > New Data Source > From Database > From SQL Server to link the hosted tables through ODBC.