Fix Microsoft Access Compact and Repair Removing the Original Database
Question details
The user needs to prevent or recover from an Access Compact and Repair operation that leaves a renamed database copy and may remove the original.
- Product
- Microsoft Access 2016
- Device & OS
- not provided
- Scenario
- Compacting an Access front-end database on network computers after an Office 2016 upgrade.
- Observed behavior
- Access reports that the original database is read-only, saves the compacted copy under another name, and may leave the original file missing.
Ask users to close the front end, and check that you have permission to create, rename, and delete files in its folder. Locate the original and any renamed compacted copy before attempting the operation again.
Compare and update Access versions and builds
Use this approach when the issue occurs on some computers but not others after the Office 2016 upgrade.
An intermittent timing issue may contribute to the behavior. Aligning Office installations is a troubleshooting step, not a guaranteed fix.
On each affected and unaffected computer, open Access and go to File > Account. Select About Access to check the version and build, and compare the results.
If Update Options is available under File > Account, select Update Options > Update Now. Otherwise, ask the Office administrator to use the update method appropriate for the installation; running a deployment script alone does not guarantee an update.
With other users out of the front end, open a test copy and select File > Info > Compact & Repair Database. Check the folder afterward to see whether the expected file remains.
Check the renamed compacted database
Use this if the original front-end file is already missing and Access left a differently named copy.
Distribute updated front ends through a launch script
Use a managed launch shortcut to simplify front-end updates and avoid compacting the shared front end on individual network computers.
Use WPS Office for documents and spreadsheets alongside Access
WPS Office is a free, lightweight alternative for everyday documents, spreadsheets, and presentations, with a familiar interface that makes migration easier. It does not repair or replace an Access database.

Frequently Asked Questions
Where can I check my Access 2016 build?
Open Access and go to File > Account > About Access. Compare the version and build with those on computers where Compact and Repair works as expected.
What if Update Options is missing from File > Account?
The installation may use a different update method or be managed by your organization. Ask your Office administrator to identify the installation type and apply the appropriate updates.
Can I use the renamed compacted database as the front end?
Possibly. Open it in Access and test its forms, connections, and expected functions first. Once verified and closed, it can be renamed to the expected front-end name if that fits your deployment.
Why use a shortcut with an update script?
A managed shortcut can copy a tested front-end release to each user's local folder before opening it. This simplifies distribution without requiring users to compact a shared front end.
Can WPS Office repair an Access database?
No. Use Microsoft Access and your organization's recovery procedures for an Access database. WPS Office can be used separately for compatible documents, spreadsheets, and presentations.




