Fix an Unrecognized Database Format Error in Microsoft Access
Question details
Recover a shared Access database when linked tables or forms report an unrecognized database format.

- 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.
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.
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.
Ask everyone using the shared database to close Access, then close your own front-end database.
In File Explorer, locate the shared ACCDB back-end file and copy it to a separate location before attempting 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.
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.

Restore a known-good Access back end
Use a working backup if Compact and Repair cannot recover the shared database.
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.

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.




