ACC2000: Name AutoCorrect Does Not Repair Report

ID: Q231634

The information in this article applies to:

Microsoft Access 2000

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 'Table or Query Name'. 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 this to be a problem in the Microsoft products 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.

REFERENCES

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:

Q231745 ACC2000: How Name AutoCorrect Works and What It Repairs

For additional information about how Name AutoCorrect works for converted databases, please see the following article in the Microsoft Knowledge Base:

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

For additional information about how Name AutoCorrect works with imported objects, please see the following article in the Microsoft Knowledge Base:

Q231676 ACC2000: Name AutoCorrect Does Not Repair Imported Objects

Additional query words: pra

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug