Query on queries

[Stewart]

I have just taken over a database with 70+ tables and 100+
queries, is there anyway to find out which queries are
dependent on which tables - without going into all the
queries to find out?

Thank you for any help you can give me on this problem.

Stewart
MOS Excel Expert (wish it was access!)

 

[[MVP] S.Clark]

Total Access Analyzer will do that, and much, much more...
http://www.fmsinc.com/products/analyzer/index.html


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-