Microsoft KB Archive/231676

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

Article ID: 231676

Article Last Modified on 10/20/2006

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition
 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q231676





Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
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.



CAUSE
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.



RESOLUTION
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.



STATUS
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.

