Update Queries after Table Field Name Changes

[Peter K]

In Access 2007 I have a set of tables in which the name of the index field
has been changed. How can I update the queries, based on these tables?

In data view I get the 'Enter Parameter Value' box. Enering the new field
name in various formats gets me no results. Trying to get into design view
the error box
'Databaser can't represent the join expression Table1.oldname=Table2.oldname
in Design View' appears. Underneath it says 'one or more fields may have
been renamed'. Yes, I know. But, how can I update the query to the new
field names?

Any help would be appreciated.

 

[Jeff Boyce]

Peter

If you are trying to do this in "data view", you probably won't succeed.

Try opening the query in "design view".

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Peter K]

That's exactly what I'm trying to do. However, the above mentioned error
message appears and won't let me get into design view.

 

[Jeff Boyce]

Peter

It may not be elegant, but sometimes I just throw away the old one and start
over.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Peter K]

I found a slightly more elegant solution:

Your response, last night made me think, there has to be a way to get to
design view directly & not just after opening the query, which brings up the
data view. So I right clicked on a query & select design view there. That
brings up the same error mesage. However, after you kill that an SQL (I
think it's SQL) version of the design view comes up & there it's a cinch to
change the field names to the new ones.

Thxs for your help. Peter K