ACC2000: Name AutoCorrect May Not Work in a Database Converted from an Earlier Version of Access (230616)


The information in this article applies to:

  • Microsoft Access 2000
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

After you convert a database to Microsoft Access 2000 and enable Name AutoCorrect, Name AutoCorrect still does not repair any name changes for fields, tables, queries, forms, or reports.

CAUSE

Even after it is enabled, Name AutoCorrect requires that each table, query, form, or report have additional information stored about the fields or the record source in order to track or apply changes made to those objects or fields. This additional information is called a Name Map.

Name Maps are not created for any tables, queries, forms, or reports that are converted from an earlier version of an Access database. Because the Name Maps are not created for tables, queries, forms, and reports in converted databases, Name AutoCorrect is not enabled by default for converted databases.

Note that Name Autocorrect only repairs changes to tables, queries, or field names in tables, queries, forms, and reports. Name AutoCorrect does not repair table, query, or field name changes in data access pages, macros, or any code. Changes to form, report, or control names are also not tracked.

RESOLUTION

To have Microsoft Access 2000 create the Name Map, do the following.

First, enable Name AutoCorrect. For Name AutoCorrect to be enabled, you must enable the Track name AutoCorrect info and the Perform name AutoCorrect properties. To enable these properties, follow these steps:
  1. On the Tools menu, click Options.
  2. Click the General tab.
  3. Make sure there is a check mark in both the Track name AutoCorrect info and Perform name AutoCorrect check boxes, and then click OK.
Second, open in Design view and save each object in which changes are to be applied or tracked. Once Name AutoCorrect has been enabled, saving the design of a table, query, form, or report will cause Microsoft Access 2000 to create the Name Map information for each saved object.

MORE INFORMATION

The steps to reproduce the behavior will save the sample database Northwind.mdb to the Microsoft Access 97 file format as NWindConv97.mdb, and then convert the database back to Microsoft Access 2000 as NWindConv2000.mdb. In the converted database, NWindConv2000.mdb, Name AutoCorrect will be disabled and the tables, queries, forms, and reports will not have the Name Map information.

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  2. On the Tools menu, point to Database Utilities, point to Convert Database, and then click To Prior Access Database Version.
  3. In the File name box, type NWindConv97.mdb. Click Save. If you receive a prompt about missing object libraries, click OK.
  4. Close Northwind.mdb.
  5. Open NWindConv97.mdb. In the Convert/Open Database dialog box, click Convert Database, and then click OK.
  6. In the File name box, type NWindConv2000.mdb. Click Save.
  7. On the Tools menu, click Options, and then click the General tab.
  8. Click to select (check) the Track name AutoCorrect info and Perform name AutoCorrect check boxes, and then click OK.
  9. Open the Customers table in Design view.
  10. Rename the CustomerID field to Cust ID.
  11. Close and save the table.
  12. Open the Customer's form.
Note that the CustomerID field shows #Name? for its value.

REFERENCES

For more information about Name AutoCorrect, click Microsoft Access Help on the Help menu, type What Name AutoCorrect fixes and doesn't fix in an Access database in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MinorLast Reviewed:7/16/2004
Keywords:kbbug kbnofix KB230616
©2004 Microsoft Corporation. All rights reserved.