ACC2000: Name AutoCorrect Doesn't Repair Query Field/Table Names

ID: Q230723

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

When you have the Name AutoCorrect feature enabled, and you make changes to a query's record source, such as changing a table name, a query name, or a field name, and you then run the query, the query may:

Prompt for the old field name value.

Return unexpected results.

Display the following error message:

"The Microsoft JET Database Engine could not find the input table or query '<Table or Query Name>'. Make sure it exists and the name is spelled correctly."

CAUSE

These symptoms may be caused by one or more of the following:

The query was built by the query wizard and either a field name or table name was changed.

-or-

The query is an action query, such as an update or append query, and the field that was changed is in an output column.

-or-

The query contains a table with a large number of fields (more than 125 fields depending on the length of the field names) and the field name that was changed is one of the last fields.

-or-

The query is based on a query that has a field with an alias and the alias was changed.

-or-

The query is based on a table in which the first field is renamed and a second field is renamed to the name of the first field.

RESOLUTION

In each of these causes, edit the relevant query to use the correct field name, table name, or alias.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: pra fix fixing

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