Troubleshoot Name AutoCorrect (MDB)

Microsoft Office Access 2003

Name AutoCorrect doesn't fix references in:

In addition, Name AutoCorrect doesn't fix references to macros in a toolbar or menu, including menu and toolbar properties and event properties that are set to macro names.

If you import or create a database object when Name AutoCorrect is not turned on, Access doesn't have enough information to enable NameAutoCorrect for that object. To enable Name AutoCorrect for the object, do the following:

  1. On the Tools menu, click Options, and then click the General tab.
  2. Select the Track name AutoCorrect info and Perform name AutoCorrect check boxes.

    If you want a log of the changes that Access makes to the database when it repairs naming errors, select the Log name AutoCorrect changes check box as well.

  3. Open the database object in Design view, save it, and close it.

ShowName AutoCorrect doesn't work in a converted database.

Microsoft Name AutoCorrect is on by default in databases that were created with Microsoft Access 2000 or later. Name AutoCorrect is automatically turned on when you convert databases created using Access 97 or earlier to Access 2003 . If Name AutoCorrect is not enabled in a converted database, do the following:

  1. On the Tools menu, click Options, and then click the General tab.
  2. Select the Track name AutoCorrect info and Perform name AutoCorrect check boxes.

    If you want a log of the changes that Access makes to the database when it repairs naming errors, select the Log name AutoCorrect changes check box as well.

ShowName AutoCorrect doesn't work for imported objects.

When you import an object into an Access 2000 or later database that has tracking enabled, the tracking information is not automatically updated for the imported objects. You must save and close the objects to enable tracking. If you import objects into an Office Access 2003 database, the tracking information for the imported objects are automatically updated.