Recover an Access Database Deleted by Compact on Close
Question details
The user needs to recover an Access database that disappeared or became inaccessible after Compact on Close.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Access was set to compact the database when it closed, and the operation may have failed or been interrupted.
- Observed behavior
- The original database is missing or inaccessible, and recent data may have been lost.
Note the database filename and its original folder, and stop saving or installing files on the affected drive to reduce the risk of overwriting recoverable data. Check whether the database was stored locally, on a network drive, or in a synced folder so you can look in the appropriate backup locations.
Check the Database Folder, Recycle Bin, and Backups
Use this method first to locate an existing copy or restore a known backup.
Open the folder where the database was stored and search for its filename and other Access database files with the .accdb or .mdb extension. Check any plausible copies without replacing the original or other candidates.
Open the Recycle Bin, search for the database filename, and use Restore if you find the file. If it was stored on a network or cloud service, also check that service's deleted-file area.
Open your backup application or synced folder's version history and look for a copy from before the compact operation. If you used Windows File History, check its saved versions for the database folder.
Restore a candidate to a separate folder, then open it in Microsoft Access and check whether the expected tables and recent records are present.

Try Specialized Recovery if No Database Copy Is Available
Use a data-recovery tool or professional service if the database is missing and no usable backup exists.
Disable Compact on Close and Compact Copies Manually
After recovering or replacing the database, use this approach to reduce reliance on automatic compaction.
Use WPS Office for Everyday Document and Spreadsheet Work
WPS Office is a free, lightweight alternative with a familiar interface for working with documents, spreadsheets, and presentations. Its Office format support helps make migration straightforward. It does not recover, open, or replace Microsoft Access databases.

Frequently Asked Questions
Can I recover an Access database without a backup?
Possibly. Search the original folder and deleted-file locations first. If no copy exists, a data-recovery tool or professional may be able to recover the file, but recovery and file integrity are not guaranteed.
Where do I turn off Compact on Close in Access?
Open the database and go to File > Options > Current Database. Clear Compact on Close and select OK. The setting applies to the current database.
What should I do if a recovered database will not open?
Keep the recovered file unchanged and work with a separate copy. You can try Access's Compact & Repair Database command on a copy when it can be opened, or consult a database recovery specialist if it remains inaccessible.
Is a .laccdb file a copy of my database?
No. A .laccdb file is a lock file used by Access; look for the actual .accdb or .mdb database in the original folder, deleted-file locations, or backups.
Can WPS Office recover or open an Access database?
No. Use Microsoft Access and appropriate backup or recovery tools for an Access database. WPS Spreadsheets can work with tabular data exported from Access to a supported spreadsheet format.




