Microsoft KB Archive/231634

= ACC2000: Name AutoCorrect Does Not Repair Report =

Article ID: 231634

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q231634



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
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:

The Microsoft Jet database engine cannot find the input table or query ' '. Make sure it exists and that its name is spelled correctly.



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



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



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



MORE INFORMATION
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.

