Editing multiple queries

[kathy miller]

I need to edit several databases with over 100 queries
each. Is there any possible way to search and replace the
information over all the queries as opposed to opening
each query to make the change. I recall in the past (much
earlier version of Access) I was able to make the change
in the MSysQueries system object table, but it now appears
that I cannot change this table at all (even though I am
admin). Any ideas?

Kathy

 

[John Vinson]

I need to edit several databases with over 100 queries
each. Is there any possible way to search and replace the
information over all the queries as opposed to opening
each query to make the change.

There are some third-party tools to do this: AFAIK you can't readily
do it in native Access.

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com