ACC2000: Name AutoCorrect Does Not Repair Imported Objects (231676)


The information in this article applies to:

  • Microsoft Access 2000
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 at the beginning of this article.

MORE INFORMATION

Steps to Reproduce 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.

REFERENCES

For additional information about Name AutoCorrect, please see the following article in the Microsoft Knowledge Base:

231745 ACC2000: How Name AutoCorrect Works and What It Repairs

Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug KB231676
©2004 Microsoft Corporation. All rights reserved.