Name AutoCorrect does not repair imported objects in Access 2000 or in Access 2002

If you import a Microsoft Access object (a table, query, form, or report) and rename a related field, the Name AutoCorrect feature does not repair the references.

Microsoft Access 2000 does not automatically create a name map for imported objects. An object must have a name map associated with it in order for Name AutoCorrect to repair that object when a field name, query name, table name, form name, or report name changes.

Microsoft Access will automatically create a name map for an imported table, query, form, or report when the Track Name AutoCorrect Info option is enabled and when the design of the object has been saved.

To enable Name AutoCorrect to track and perform name changes, click the Tools menu, click Options, and then click the General Tab. Click to select the Track Name AutoCorrect Info and Perform Name AutoCorrect check boxes. This enables Name AutoCorrect.

Once Name AutoCorrect has been enabled, open any objects that you have imported in Design view and save them.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was fixed in Microsoft Office Access 2003.

Steps to reproduce the behavior

1. Start Microsoft Access and create a new blank database.
2. Make sure Name AutoCorrect is enabled by clicking the Tools menu, clicking Options, and then clicking the General tab. Ensure that the Track Name AutoCorrect Info and Perform Name AutoCorrect check boxes are selected (checked). If they are not selected, click to select them. This enables Name AutoCorrect.
3. On the File menu, point to Get External Data, and then click Import.
4. Select the sample database Northwind.mdb.
5. In the Import Objects dialog box, select the Customers table from the Table tab and the Customers form from the Forms tab.
6. Click OK.
7. Open the Customers table in Design view.
8. Rename the CustomerID field to CustID.
9. Close and save the table.
10. Open the Customers Form.
    Note that even though Name AutoCorrect is enabled, changing the CustomerID field to CustID now causes the Customers form to show #Name? for the CustomerID control.

For more information about the Name AutoCorrect feature, click the following article number to view the article in the Microsoft Knowledge Base: