whats the easiest way to change a query name

[smiley0q0]

I can change the name of the query but then any other queries that are linked don't recognise the change, they still look for the old name. is there a way to change the name and have everything that is linked to it realise that it changed?

 

[LarryDeLaruelle]

jtaylor1074:

I believe Access 2000 may do that, or so I've heard. (It is supposed to propagate field name changes to queries, forms and reports so maybe it will also do query name changes.)

In Access 97, your best bet will be to open each query that is based on the one that was name-changed then open the SQL view (View from the Menu; SQL View).

There is no find and replace feature so you will need to find each instance where the old query name is referenced in the SQL code and manually change it to the new name.

Pain in the posterier, I know since I've had to do this once or twice, but it is one way to accomplish what you need.

Depending on how many queries you have based on the original and how complex they are, it may be faster to just recreate them.
Larry De Laruelle
larry1de@yahoo.com

 

[PaulF]

Access 2K has a built-in utility that I've never used.

For Access 97
By using a third party utility such as

Speed Ferret costs ($129 - $149)

http://www.moshannon.com/speedferret.html

or

Rick Fisher's Find And Replace costs $39 dollars
I've used this one before, and its easy to use and does the job.
Get Shareware evaluation copy at

http://www.rickworld.com/products.html

PaulF

 

[smiley0q0]

i am using 97, so i will see what i can do. i do appreciate your help. Thank you.