Microsoft KB Archive/96545

= ACC: Changed Field Names in Table Are Not Reflected in Query =

Article ID: 96545

Article Last Modified on 5/9/2003

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q96545



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



SYMPTOMS
If you create a query using an existing table and then change a field name in that table, the new field name does not show in the query grid when the query is reopened. The old field name in the query grid has been made into an expression similar to this:

  Expr1: TableName.[Old FieldName]



CAUSE
Changes to table field names do not propagate up through the queries based on that table.



RESOLUTION
Replace the new expression in the field cell of the query grid with the correct field name from the table. The field list in the upper half of the query window will show the current field names.



STATUS
This behavior is by design.



MORE INFORMATION
This behavior actually preserves the original query so that you can see what was originally included in the query.

Steps to Reproduce Behavior
  Create the following table. Save it, and enter a few records:

     Table: Table1 Field Name: OldName Data Type:  Text   Create the following query adding the table that you created in step 1:

     Query Name: Query1 ---     Field Name: OldName Show:      True  Run the query. Note that data in the OldName field shows up in Datasheet view of the query.</li> Open the Table1 table in Design view and change the OldName field to NewName. Close and save the table.</li>  Open the Query1 query in Design view. Note that the field cell now shows the following:

<pre class="fixed_text">     Expr1: Table1.[OldName]

If you run the query, this field will be blank. To correct this, choose NewName from the list in the field cell of the query. </li></ol>

Additional query words: update structure

Keywords: kbprb kbusage KB96545

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.