File Corruption & Recovery

Fix Microsoft Access Database Compact, Repair, and Save Errors

Kushani NimanthikaKushani Nimanthika Nov 14, 2026 868 views

Question details

The user needs to resolve errors preventing an Access database from being compacted, repaired, or saved.

Fix Microsoft Access Database Compact, Repair, and Save Errors
Product
Microsoft Access
Device & OS
not provided
Scenario
The user is trying to save or maintain an Access database.
Observed behavior
Access may fail to compact, repair, or save the database.
Before you start

Ask other users to close the database, and check that you can access its folder. Make a copy of the database file before attempting a repair or changing its objects.

Solution 1Recommended

Close hidden Access processes and check folder permissions

Use this first to rule out a lingering Access process or insufficient access to the database folder.

1
Close Access

Close all open Access databases and exit Microsoft Access on your computer.

2
Check for hidden processes

Open Task Manager, find any remaining Microsoft Access processes, and select End task. Restart the computer, then reopen Access.

3
Check permissions

In File Explorer, right-click the database folder and choose Properties > Security. Confirm that your account can read, write, create, and delete files in the folder and has access to the database file.

4
Try compacting again

With other users disconnected, open Access and select File > Info > Compact & Repair Database. Check whether the database can also be saved.

Close hidden Access processes and check folder permissions
Shared database: Access needs sufficient folder permissions to create temporary files during compacting. If you cannot change permissions, contact the folder administrator.
Free Microsoft Office alternative

Use WPS Office for spreadsheet and document work

WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format support for an easier transition. WPS does not open or repair Access databases; use Microsoft Access for database recovery.

Work with tabular data in WPS Spreadsheets after exporting it from AccessOpen and edit Microsoft Excel XLSX files and other common Office formatsUse a familiar interface for spreadsheets, documents, and presentationsGet a free, lightweight office suite for everyday tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access need permission to write to the database folder?

Access may need to create lock and temporary files in the folder, including during compacting. Check the folder's Properties > Security settings for read, write, create, and delete access.

Can I compact a database while other people are using it?

Ask all users to close the database first. Compacting and repairing generally requires exclusive access to the database file.

Where do I turn off Compact on Close?

Open the database and go to File > Options > Current Database. Clear Compact on Close, select OK, and reopen the database.

What should I do if objects will not import into a new database?

Try importing smaller groups through External Data > New Data Source > From Database > Access to identify the failing object. If required data remains inaccessible, restore a known-good backup or seek specialist recovery help.

Can WPS Office repair an Access database?

No. Use Microsoft Access to compact, repair, or import an Access database. WPS Spreadsheets can work with tabular data exported to a supported format such as XLSX.