OneDrive File Issues

Fix Microsoft Access Changes Not Saving in OneDrive

Olivia MillerOlivia Miller Nov 14, 2026 868 views

Question details

The user needs a reliable way to save changes to a Microsoft Access database shared through OneDrive.

Why Microsoft Access Changes Are Not Saved in OneDrive
Product
Microsoft Access and OneDrive
Device & OS
not provided
Scenario
Opening and editing an ACCDB database stored in a shared OneDrive folder.
Observed behavior
Changes may not save reliably because Access performs continuous database operations while OneDrive synchronizes files.
Before you start

Identify where the ACCDB file is stored and whether anyone else is using it. Make sure all users close the database before moving or replacing the shared copy.

Solution 1Recommended

Move the Access Back End to a Suitable Shared Location

Use this approach when multiple people need to work with the database.

OneDrive is not a reliable live multiuser location for an Access database. A common alternative is to split the database, keep its back-end tables on a suitable shared network location, and give each user a local front-end copy.

1
Close the shared database

Ask every user to close the ACCDB file in Access before changing its location.

2
Split the database

Open the database in Access and choose Database Tools > Access Database to start the Database Splitter wizard.

3
Place the back end

Use the wizard to create the back-end file in a suitable shared network folder outside OneDrive. Confirm that users have the required folder permissions.

4
Distribute local front ends

Give each user a local copy of the front-end file and use External Data > Linked Table Manager to verify or update its links to the shared back end.

Move the Access Back End to a Suitable Shared Location
Consider a database server: For remote access or more demanding multiuser workloads, consider a database server designed for multiple users rather than sharing an ACCDB file through OneDrive.
Free Microsoft Office alternative

Work With Exported Access Data in WPS Spreadsheets

WPS Office is a free, lightweight alternative for everyday document and spreadsheet work, with a familiar interface and Microsoft Office format support for an easier move. Export Access data to Excel first if you want to review it in WPS Spreadsheets; WPS does not fix Access database synchronization or replace Access database features.

Review Access data exported to an Excel workbookOpen and edit Microsoft Excel XLSX filesWork with Word DOCX and PowerPoint PPTX filesUse a familiar interface in a lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why is OneDrive unreliable for a live Access database?

Access makes continuous changes to its database file, while OneDrive synchronizes files between locations. This can cause conflicts or incomplete updates, especially when more than one person uses the database.

Can multiple users edit an ACCDB file in a shared OneDrive folder?

A shared OneDrive folder should not be used as a live multiuser Access location. Instead, consider a split database with a suitable shared network back end and local front ends, or a database server.

Can I keep an Access database in OneDrive if only one person edits it at a time?

Yes, for controlled asynchronous work: download the latest file from OneDrive, edit it in a local folder outside OneDrive, close Access, and upload the updated copy. Coordinate with other users so nobody overwrites a newer version.

Can WPS Office open an Access database directly?

WPS Office is not a replacement for Access database features. To review table data in WPS Spreadsheets, export it from Access using External Data > Excel, then open the exported workbook in WPS.