Select the product you need help with

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

Expand all | Collapse all

SYMPTOMS

Consider the following scenario:

You open an earlier version of the Access database in Microsoft Access 2002 or in Microsoft Access 2000.
You convert the database to the Access 2002 format or to the Access 2000 format.
You enable the Name AutoCorrect feature for the database.

In this scenario, the Name AutoCorrect feature does not work. When you change the name of an object or of a field, the names that are referenced in other objects are not changed automatically.

Note This issue also occurs when you try to import Access 2002 objects to an Access 2002 database.

Back to the top | Give Feedback

CAUSE

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.

Back to the top | Give Feedback

RESOLUTION

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:

In Access 2002 or in Access 2000, open the database.
On the Tools menu, click Options.
Click the General tab.
Click to select the Track name AutoCorrect info check box and the Perform name AutoCorrect check box, and then click OK
For the following objects, click Design to open a design view, and then click Save. Do this for each object in the order in which they appear in this list.
- Queries
- Forms
- Reports
A name map is created for each object in the database.

Note If you save a form or a report first, the correct name map information of the relevant query is not saved in the form or in the report. Therefore, you must save the objects in the order in which they appear in this list.

Back to the top | Give Feedback

MORE INFORMATION

Steps to reproduce the issue

In Access 2000, open the Access 97 version of the sample database Northwind.mdb.
In the Convert/Open Database dialog box, click Convert Database, and then click OK.
In the File name box, type NWindConv2000.mdb, and then click Save.
On the Tools menu, click Options, and then click the General tab.
Click to select the Track name AutoCorrect info check box and the Perform name AutoCorrect check box, and then click OK.
Open the Customers table in Design view.
Rename the CustomerID field to Cust ID.
Save and then close the table.
Open the Customers form. The CustomerID field displays the following value:
#Name?

Back to the top | Give Feedback

REFERENCES

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.

Back to the top | Give Feedback