Globally rename a query?

[Jon]

I've run into a snag of my own making and I'm hoping for some help...

I've been working on an ad-hoc database in Access 2002 and I've
created a large number of queries using semi-descriptive names - one
example is a query that's actually called
qryAllShiftTotalEfficiencyForMonthFromCBO (yes I know that's a
mouthful). That query is used in a couple of other querys (qryThis and
qryThat) plus also a graph on at least one report, maybe two. The
problem is that the number of queries using those long names has
multiplied and it's getting hard for me to keep track of them all.
What I would like to do is to rename qryAllShift to something more
compact - say qryTotEffView1.

How can I get Access to automatically rename all instances of
qryAllShift to qryTotEffView1?

Alternately how can I get Access to tell me all locations where
qryAllShift is used so I can manually change them?

 

[Guest]

Name Autocorrect might do it for you; however, I find it about useless.

Rich Fisher's excellent Find and Replace add-in might be just the ticket. If
you register it (one of the best $37 I've ever spent), the cross-reference
report can find what queries use which reports and forms. It's a good way to
find orphans.

http://www.rickworld.com/