Use a Microsoft Access Split Database with a Cloud Back End
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.

- 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.
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.
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.
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.
Move the back-end .accdb file to the shared folder. Use the shared network path rather than a cloud-synchronized folder.
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.
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.

Migrate the Tables to Azure SQL Database and Link Access
Use a hosted SQL database when users need a cloud-based back end rather than a synchronized Access file.
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.

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.




