finding tables in queries

  • Thread starter Thread starter andy
  • Start date Start date
A

andy

I inherited a database that uses about 60 queries. Due to a change in
years, I need to swap out tables. Other than looking at design view for
all of the queries involved, is there a simple way to find out which
queries use a particular table? Even better is there a utility or a short
piece of code to swap out the tables used in the queries? Each table has
the same fields.

Thank you!
 
I inherited a database that uses about 60 queries. Due to a change in
years, I need to swap out tables.
Click to expand...

WUFF! Not in a properly designed database, you don't!

You should NOT store data - a year - in a tablename. Normally you
would store a date field in the Table, and use Queries to select the
data for a particular year.
Other than looking at design view for
all of the queries involved, is there a simple way to find out which
queries use a particular table? Even better is there a utility or a short
piece of code to swap out the tables used in the queries? Each table has
the same fields.
Click to expand...

It's not really easy in native Access (I understand that there is some
improvement in the otherwise unreliable Name Autocorrect feature in
2003 but I still wouldn't trust it). Some third party software vendors
have filled this gap:

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
 
Thanks for your help. Like I mentioned I inherited this database and
you're right - the whole mess is poorly designed. However, until I get
to rewrite it, I'm stuck with it. Thanks!
 
Back
Top