File Sharing Problems

How to Share a Microsoft Access Database Using OneDrive or SharePoint

WPS Editor Oct 9, 2026 870 views

Question details

The user wants to know how to properly share a Microsoft Access database with multiple users using cloud services like OneDrive or SharePoint.

How to Share a Microsoft Access Database Using OneDrive or SharePoint

Product: Microsoft Access
Device & OS: not provided
Scenario: Attempting to collaborate on an Access database file simultaneously over a network or cloud syncing service.
Observed behavior: Syncing an Access database via OneDrive or SharePoint causes file conflicts and overwrites data because synchronization only occurs after the file is closed, preventing real-time co-authoring.

Before you start

Before attempting to share or split your database, ensure all users have the appropriate network permissions and create a backup copy of your original database file to prevent accidental data loss.

Solution 1Recommended

Split the Access Database on a Shared LAN Folder

The most reliable method for multiple users is to separate the data (back-end) from the application interface (front-end) over a local area network.

Unlike Microsoft Word or Excel, Access databases do not support simultaneous real-time co-authoring via OneDrive or SharePoint. If multiple users open a OneDrive-synced Access file, they will overwrite each other's changes. Splitting the database solves this by giving each user their own application interface linked to a central data file hosted on a shared network drive.

Open the Database Splitter Wizard

Open your Microsoft Access database and navigate to the 'Database Tools' tab on the top ribbon. Click on 'Access Database' in the Move Data group to launch the Database Splitter Wizard.

Create the Back-End Database

Follow the wizard prompts to create the back-end database, which will contain only the tables. Save this new back-end file to a secure, shared LAN folder that is accessible to all intended users.

Distribute the Front-End Copy

Once split, the original file becomes the front-end (containing queries, forms, and reports). Distribute a copy of this front-end database to each user's local computer so they can interact with the central data without file lock conflicts.

Split the Access Database on a Shared LAN Folder

Avoid OneDrive for Back-end Storage: Never place the split back-end database in a OneDrive or SharePoint synced folder. File synchronization delays will inevitably cause database corruption and data loss.

Solution 2

Migrate the Database Back-End to SQL Server or Azure SQL

For true cloud-based database collaboration without relying on a local network, migrate your data to a dedicated SQL server.

Solution 3

Use Remote Desktop Services for Wide Area Networks

If users are spread across different locations (WAN), allow them to remote into a computer that sits on the same local network as the database.

Free Microsoft Office alternative

Enjoy Seamless Cloud Collaboration with WPS Office

While Microsoft Access requires complex network configurations for multi-user sharing, your standard document collaboration shouldn't be a hassle. WPS Office offers a lightweight, highly compatible alternative for Word, Excel, and PowerPoint files with built-in cloud support for flawless real-time co-authoring.

1. Download WPS Office: Visit the official WPS website and click the download button to get the free installer for your operating system.
2. Install the Application: Run the downloaded file and follow the on-screen instructions to install WPS Office on your device.
3. Collaborate in the Cloud: Open WPS Office, sign in, and start co-authoring documents, spreadsheets, and presentations with your team in real time.

Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Built-in cloud sharing capabilities that natively support simultaneous real-time document collaboration.Lightweight installation with a familiar, easy-to-use tabbed interface for quick transitions.Completely free to use, serving as a powerful alternative to expensive Office subscriptions.

microsoft office alternative - wps office

Frequently Asked Questions

Can I co-author an Access database on SharePoint like I do with Word?

No, Microsoft Access does not support real-time co-authoring in a web browser. Opening an Access file from SharePoint or OneDrive locks the file or creates an isolated local copy, leading to severe version conflicts if multiple people make changes simultaneously.

What happens if two people edit an Access database on OneDrive at the same time?

OneDrive downloads a local copy to each user's computer. The sync process only triggers after the database application is closed. If both users make changes, the last person to close and sync their file will completely overwrite the data entered by the first person.

Is there any reliable way to use Microsoft Access in the cloud?

Yes, but not through standard file-hosting services like OneDrive or Dropbox. You must migrate the back-end (the tables) to a cloud-based SQL database like Azure SQL, or use remote desktop software to access a machine that is running the database locally.

Document & File Issues