Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


More information

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.

↑ Back to the top


References

For more information about the Name AutoCorrect feature, click the following article number to view the article in the Microsoft Knowledge Base:
231745 How Name AutoCorrect works and what it repairs

↑ Back to the top


Keywords: KB231676, kbbug

↑ Back to the top

Article Info
Article ID : 231676
Revision : 3
Created on : 10/20/2006
Published on : 10/20/2006
Exists online : False
Views : 438