what queries are linked to a particular table?

[joeMan]

IS there any way to see what queries are linked to a
particular table in a database? I have a database that
conatins hundreds of queries and tables.
Thanks!

 

[RobFMS]

If you're seriously talking about 100s of tables and queries, then I would
recommend looking at Total Access Analyzer.
http://www.fmsinc.com/Products/analyzer/2000/convince.html

http://www.fmsinc.com/Products/analyzer/index.html

There is a free trial version for you to download.


--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Guest]

You might be able to locate them if you are using Access 2003. It has useful utility "Property Scanner"; you can find it under "Tools"/"Add-ins"

 

[joe man]

Thanks. I don't think the bosses are going to spend a
dime though. Maybe some code would do the trivk?
Dunno..i'll keep loooking. Thanks for the tip !

 

[John Vinson]

IS there any way to see what queries are linked to a
particular table in a database? I have a database that
conatins hundreds of queries and tables.
Thanks!

This isn't very easy in native Access, but there are some good
third-party crossreference tools that can help:

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