ACC2000: Name AutoCorrect Does Not Repair Report

Even though Name AutoCorrect is enabled to track and perform changes in your database, when you open a report after changing a field name, a query name, or a table name, you are prompted for the old field name, or you receive the following error message:

If the record source for a report is a SQL SELECT statement, Name AutoCorrect repairs the SQL statement. However, Name AutoCorrect does not repair any controls on the report, the Filter or OrderBy properties, or values in the Field/Expression list of the Sorting and Grouping dialog box. Therefore, the report prompts you for the old field name's value when you open the report.

To correct this problem, open the report in Design view and manually change the control or property that Name AutoCorrect did not fix.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

If the report was imported or converted from an earlier version of Microsoft Access, or if the Track name AutoCorrect info option was disabled when the report was created, the report doesn't have the name map information that Microsoft Access needs to repair name changes.

To have Access create the name map information for the report, be sure the Track name AutoCorrect info and Perform name AutoCorrect options are enabled. To do so, on the Tools menu, click Options, and then click the General tab. If there are no check marks in the Track name AutoCorrect info and Perform name AutoCorrect check boxes, click to select the check boxes. This enables Name AutoCorrect.

After enabling Name AutoCorrect, open the source of the report in Design view and save it, and then open the report in Design view and save it. Doing so causes Access to create the name map for the report and its source.

For additional information about how Name AutoCorrect works and what it repairs and doesn't repair, please see the following article in the Microsoft Knowledge Base: For additional information about how Name AutoCorrect works for converted databases, please see the following article in the Microsoft Knowledge Base: For additional information about how Name AutoCorrect works with imported objects, please see the following article in the Microsoft Knowledge Base: