Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Name AutoCorrect Does Not Repair Query Field/Table Names
Article ID: 230723 - View products that this article applies to.
This article was previously published under Q230723
Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
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:
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.
The query is an action query, such as an update or append query, and the field that was changed is in an output column.
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.
The query is based on a query that has a field with an alias and the alias was changed.
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.
In each of these causes, edit the relevant query to use the correct field name, table name, or alias.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.