File Corruption & Recovery

Fix Microsoft Access Compact and Repair Removing the Original Database

Elise WilliamsElise Williams Nov 22, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Check each build

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.

2
Update inconsistent installations

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.

3
Retest on a copy

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.

Free Microsoft Office alternative

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.

Keep working on documents and spreadsheets while an administrator troubleshoots the Access front end.Open and edit common Microsoft Office formats, including DOCX, XLSX, and PPTX.Use a familiar interface for a smoother move from Microsoft Office.Install a free, lightweight suite for everyday office tasks.
microsoft office alternative - wps office

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.