Microsoft KB Archive/230616

= 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

Article Last Modified on 3/6/2007

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition
 * Microsoft Access 2000 Standard Edition

-



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



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.



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.



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. <ul> Queries</li> Forms</li> Reports</li></ul>

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.</li></ol>

<div class="moreinformation_section">

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


 * 1) Name?

</li></ol>

<div class="references_section">