The Name AutoCorrect feature in MS Access lets you eliminate the inconsistencies in the databases, which are triggered by renaming certain objects in the database. This feature, when enabled, repairs the deviations in the database. It repairs forms, queries, reports, tables, and controls on forms and reports. However, at times this feature can cause corruption in Access database. In such cases, you should take appropriate corrective measures to resolve the issue. In case, if you are unable to do so, then you should use third-party Access database repair software to repair Access file.

Consider a scenario wherein you are working on a table in an Access 2007 database. You try to save a modified query and Access quits unexpectedly without any error message. When you open the table again, you are unable to do so.

Cause:

The root cause of this situation is that you have enabled the Name AutoCorrect option, because of which Access is quitting unexpectedly. And as Access exited abruptly, the table has corrupted and, thus, is now inaccessible.

Resolution:

To resolve this situation and to access the corrupted table, you should perform the following steps:

  1. Create a new database.
  2. Disable Name AutoCorrect option by following Access 2007: Office Button | Access Options | Current Database.
  3. Import the tables by selecting External Data | Import | Access.
  4. Import other objects such as queries, forms, reports, macros, modules, etc.
  5. Set minimal References under Tools | References from the Code window.
  6. Compile using the Debug menu from the Code window. It should resolve the issue now.

However, if you are not able to address the situation then you should use a third-party Access database repair tool to repair Access database. This tool is able to repair the Access database using fast yet sophisticated scanning algorithms.

Stellar Phoenix Access Recovery is an Access database repair tool that is able to perform Access file repair on corrupted databases created in Access 2000, 2002, 2003, and 2007. It is capable of repairing various Access components such as tables, reports, queries, forms (with VBA code), macros, and modules. In addition, this Access repair tool is able to repair various fields such as AutoNumber, Yes/No, OLE object fields, Hyperlink, etc. It is compatible with Windows 7, Vista, Server 2003, XP, and 2000.