Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC2000: Name AutoCorrect Does Not Repair Report
Article ID: 231634 - View products that this article applies to.
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).
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 'Table or Query Name'. Make sure it exists and that its name is spelled correctly.
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:
231745For additional information about how Name AutoCorrect works for converted databases, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/231745/EN-US/ )ACC2000: How Name AutoCorrect Works and What It Repairs
230616For additional information about how Name AutoCorrect works with imported objects, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/230616/EN-US/ )ACC2000: Name AutoCorrect May Not Work in a Database Converted from an Earlier Version of Access
(http://support.microsoft.com/kb/231676/EN-US/ )ACC2000: Name AutoCorrect Does Not Repair Imported Objects