Compact And Repair Database. Since its a free solution you must try it before anything else. When you apply Compact and Repair on a corrupt file it can happen that once the operation is complete some objects tables or records might be deleted from the database if they were failing or producing errors.
Automatically compact and repair a database when it closes. You might notice the Compact and repair button on the ribbon requires an exclusive lock closes the database then. Today I attempted to compact and repair an Access database and received the above message.
You will see the Database to compact from dialog box.
By executing certain commands in the Command Line tool Command Prompt of your system you can compact and repair the corrupted Microsoft Access database file. Go to Tools and select Database Utilities. In the following pop-up box navigate the damage database file and then press OK. Also its very useful when a database file becomes large and causes slow performance in Access program.
