ACC2000: Name AutoCorrect Does Not Repair Imported Objects

ID: Q231676

The information in this article applies to:
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 this to be a problem in the Microsoft products 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.



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

Additional query words: pra 


Keywords          : kbdta 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: June 10, 1999