File Corruption & Recovery

Fix an Unrecognized Database Format Error in Microsoft Access

Algirdas JasaitisAlgirdas Jasaitis Nov 20, 2026 868 views

Question details

Recover a shared Access database when linked tables or forms report an unrecognized database format.

Fix an Unrecognized Database Format Error in Microsoft Access
Product
Microsoft Access
Device & OS
not provided
Scenario
A front-end Access database uses tables linked to a shared ACCDB back end.
Observed behavior
The front end opens, but accessing linked tables or forms produces an unrecognized database format error.
Before you start

Identify the shared ACCDB back-end file and ask all users to close their Access databases before repair. Make a copy of the back-end file so you can preserve its current state before running Compact and Repair.

Solution 1Recommended

Compact and repair the shared Access back-end database

Use this method when the linked ACCDB back end may be corrupted, even if the front end opens normally.

1
Disconnect users

Ask everyone using the shared database to close Access, then close your own front-end database.

2
Copy the back end

In File Explorer, locate the shared ACCDB back-end file and copy it to a separate location before attempting the repair.

3
Run the repair

Open Access without opening a database, select Database Tools > Compact and Repair Database, and choose the shared back-end ACCDB file when prompted.

4
Test the linked objects

Open the front-end database and try the affected linked tables and forms. If links need updating, open External Data > Linked Table Manager and refresh the links to the back end.

Compact and repair the shared Access back-end database
Repair the back end: Compacting and repairing an open front end does not necessarily repair its separate linked back-end file. Select the back-end ACCDB for repair.
Free Microsoft Office alternative

Use WPS Office for everyday documents and spreadsheets

WPS Office is a free, lightweight alternative for working with documents, spreadsheets, and presentations in a familiar interface. Its Microsoft Office format compatibility makes it easy to move existing files. It does not repair Access databases or replace Access for ACCDB applications.

Work with spreadsheet data alongside your Access recovery workflowOpen and edit common Microsoft Office formats, including DOCX, XLSX, and PPTXUse a familiar interface for everyday office tasksAccess lightweight office tools for free
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access front end open when the linked tables fail?

The front end and back end are separate files. The front end can open normally while the shared ACCDB containing the linked tables is corrupted. Try Compact and Repair on the back-end file.

Do other users need to close the database before I repair it?

Yes. Ask all users to close their Access databases before running Database Tools > Compact and Repair Database on the shared back end.

What should I do if Compact and Repair does not work?

Keep a copy of the damaged ACCDB, then restore a known-good backup to the shared location. Open the front end and test its linked tables and forms.

How do I reconnect tables after restoring the back end?

In the front-end database, open External Data > Linked Table Manager and refresh or update the links to point to the restored ACCDB file.