Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
The Name AutoCorrect feature does not work after you convert an earlier version of the Access database to the Access 2002 format or to the Access 2000 format
Article ID: 230616 - View products that this article applies to.
This article was previously published under Q230616
Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
Consider the following scenario:
Note This issue also occurs when you try to import Access 2002 objects to an Access 2002 database.
This issue occurs because earlier versions of Access do not have the Name AutoCorrect feature. To track the name of an object or of a field, each object should contain the necessary additional information about the field or record source. This additional information is called a name map. A name map is not created for tables, queries, forms, or reports that are converted from an earlier version of the Access database. Therefore, the Name AutoCorrect feature does not work.
To resolve this issue, you must manually create a name map for each object in the database that is converted from an earlier version of the Access database. To do this, follow these steps:
Steps to reproduce the issue
For more information about the Name AutoCorrect feature, click Microsoft Access Help on the Help menu, type What Name AutoCorrect fixes and does not fix in an Access database in the Office Assistant or the Answer Wizard, and then click Search to view the topic.