File Corruption & Recovery

Fix Microsoft Access Database Compacting on Startup and Exit

Steven ParkerSteven Parker Nov 14, 2026 868 views

Question details

Determine why an Access database compacts when it opens and closes, and rebuild it if corruption is suspected.

Product
Microsoft Access
Device & OS
not provided
Scenario
An Access database appears to compact at startup and exit.
Observed behavior
The database compacts when opened and closed, potentially because of a setting, an automated process, or corruption.
Before you start

Ask other users to close the database, and confirm that you can access all linked data sources. Identify whether the file is split into a front end and back end before changing settings or importing objects.

Solution 1Recommended

Rebuild the Access Database by Importing Its Objects

Use this approach if corruption is suspected or the database continues to behave unexpectedly.

1
Create a blank database

In Access, select File > New > Blank database, choose a new file name and location, and select Create.

2
Import database objects

In the new database, select External Data > New Data Source > From Database > Access. Browse to the original file, choose to import tables, queries, forms, reports, macros, and modules, and select the objects to import.

3
Check links and settings

Open External Data > Linked Table Manager to check linked tables, and review File > Options > Current Database for startup settings that may need to be recreated.

4
Test the rebuilt database

Open the imported forms, reports, queries, and macros, and test normal workflows. Close and reopen the new database to see whether the unexpected compacting continues.

Rebuild the Access Database by Importing Its Objects
Check items that may not transfer: Importing objects may not reproduce every database-level setting, reference, relationship, or startup option. Verify these in the rebuilt file before putting it into use.
Free Microsoft Office alternative

Work With Exported Access Data in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface for working with exported database data. Open Excel or CSV exports in WPS Spreadsheets for a straightforward transition, but use Access to manage or repair the original database.

Review and analyze data exported from Access in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX filesUse familiar spreadsheet tools in a lightweight Office suiteMove exported tabular data into WPS using Excel or CSV files
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access compact my database when I close it?

Compact on Close may be enabled. Open File > Options > Current Database and check the Compact on Close option. Exit-time automation may also trigger a compact operation.

Does Compact on Close also compact the database at startup?

No. Compact on Close applies when the database closes. For startup compaction, inspect the AutoExec macro, startup form, launch shortcut, scripts, and scheduled tasks.

How do I import Access objects into a new database?

Create a blank database, then select External Data > New Data Source > From Database > Access. Browse to the original database and choose the objects to import.

Why does my Access database grow so quickly?

Repeated imports, large temporary tables, and queries that add or delete data can contribute to growth. Review and test those routines to find the source rather than relying on frequent compaction.

Can WPS Office repair an Access database?

No. Use Microsoft Access to review compacting settings and rebuild the database. WPS Spreadsheets can work with data exported from Access to Excel or CSV.