Fix Microsoft Access Database Compact, Repair, and Save Errors
Question details
The user needs to resolve errors preventing an Access database from being compacted, repaired, or saved.

- 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.
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.
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.
Close all open Access databases and exit Microsoft Access on your computer.
Open Task Manager, find any remaining Microsoft Access processes, and select End task. Restart the computer, then reopen Access.
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.
With other users disconnected, open Access and select File > Info > Compact & Repair Database. Check whether the database can also be saved.

Disable automatic compacting and Name AutoCorrect
Try these database settings if the file opens but saving or maintenance still fails.
Test database objects in a new Access database
Use a new blank database to help isolate damaged objects or database corruption.
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.

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.




