Recover a Microsoft Access Database Stopped by a Data Conflict
Question details
User needs to recover a Microsoft Access database that can no longer be opened after Access reports a data conflict caused by two users attempting to change the same data.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Two users attempted to change the same data in an Access database, and now the database cannot be opened or fully recovered.
- Observed behavior
- The database reports a data conflict and cannot be opened or fully recovered with existing methods.
Identify your most recent backup and verify how current it is before attempting any repair. Always create a copy of the affected .ACCDB or .MDB file and run recovery steps on the copy, not the original.
Restore the Most Recent Access Backup
Use this first if you have a backup database, even if the backup file size is smaller than the current corrupted file.
Backups are often the fastest and safest recovery path. A size difference such as 623 MB versus 693 MB may still be acceptable if the backup contains the most recent usable records.
Open File Explorer and go to the folder where your Access database backups are stored. Select the most recent .ACCDB or .MDB backup file.
Right-click the backup file, choose Copy, then paste it into a new recovery folder so you do not overwrite the backup.
Double-click the copied backup file or open Microsoft Access, click Open, and browse to the recovery copy to confirm the data is readable.

Decompile and Compact the Conflicted Access Database on a Copy
Use this when the database remains inaccessible or partially opens but still reports corruption after a data conflict.
Use Professional Database Recovery for Critical Access Data
Consider this if the backup is outdated and built-in decompile or compact/repair does not restore access to important data.
Recover Your Office Workflow with WPS Office While You Address Access Database Corruption
WPS Office does not include a Microsoft Access database engine and cannot repair ACCDB or MDB corruption directly. As a free, lightweight Microsoft Office alternative, WPS Office lets you continue working with compatible Word, Excel, and PowerPoint files while you restore or rebuild your Access data.
- 1. Download WPS Office: Go to the WPS Office download page and install the free version on your Windows PC.
- 2. Open your existing Office files: Launch WPS Office and open your Word, Excel, or PowerPoint files directly from the WPS Office home screen.
- 3. Continue working while Access is repaired: Use WPS Writer, Spreadsheets, or Presentation to edit and save compatible Microsoft Office files without an Office 365 subscription.

Frequently Asked Questions
Can WPS Office open or repair a Microsoft Access database?
No, WPS Office does not include Microsoft Access and cannot open, compact, or repair .ACCDB or .MDB database files. Use Microsoft Access backup, decompile, compact/repair, or a professional Access recovery service.
Why does Access report that two users attempted to change the same data?
Access detects a write conflict when an edit conflicts with changes made by another user before the record was saved. If the conflict is not resolved correctly, the database can become marked as corrupted or fail to open.
Should I repair the original Access database file directly?
No. Always copy the original .ACCDB or .MDB file to a separate folder and run decompile or compact/repair on the copy. Repairing the only original can cause permanent data loss.
How do I know if my Access backup is current enough?
Open the backup copy and compare the latest records, table counts, or timestamps with your expected data. A smaller file size such as 623 MB versus 693 MB can still be usable if the most recently changed records are present.
What is the Access decompile procedure?
Press Windows + R, type msaccess /decompile, press Enter, and then open the copied database. After decompiling, run Compact and Repair Database from the Database Tools tab, then reopen the file to check for errors.




