Deleted File Recovery

Recover an Access Database Deleted by Compact on Close

Elise WilliamsElise Williams Nov 14, 2026 868 views

Question details

The user needs to recover an Access database that disappeared or became inaccessible after Compact on Close.

Recover an Access Database Deleted by 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.
Before you start

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.

Solution 1Recommended

Check the Database Folder, Recycle Bin, and Backups

Use this method first to locate an existing copy or restore a known backup.

1
Search the original folder

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.

2
Check deleted files

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.

3
Look for backup versions

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.

4
Test a restored copy

Restore a candidate to a separate folder, then open it in Microsoft Access and check whether the expected tables and recent records are present.

Check the Database Folder, Recycle Bin, and Backups
Lock files are not database backups: A .laccdb or .ldb file is a lock file, not a replacement for the .accdb or .mdb database.
Free Microsoft Office alternative

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.

Free, lightweight tools for common office tasksCompatible with Microsoft Word, Excel, and PowerPoint formats, including DOCX, XLSX, and PPTXA familiar interface for a smoother transition from Microsoft OfficeSpreadsheet tools for working with tabular data exported from Access
microsoft office alternative - wps office

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.