Relationship Table for other objects

[Navyguy]

I am looking for an easier way to confirm that all a queries that are in a database are being used by the database. I started going through each and every one and it is taking for ever!

I have tried the documenter and either I cannot understand it properly or it does not contain the information that I am looking for.

An example might be I have a query called qryOne. I want to see where it is being used so I am looking for a “list” that says

qryOne = rptOne
qryOne = rptSix
qryOne = rptEightySix

Obviously these are just made up names, but I hope you understand what I am looking for. In essence a relationship table for queries, forms and reports.

Thanks for your help

 

[llkhoutx]

You need the 3rd party tool, Speed Ferret. You can find it via Google.

 

[Navyguy]

Thank you

I will check it out. I was hoping that I just could not use the documenter properly...

Cheers