Editing multiple queries

K

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top