Is there a way...

[Tara]

I just inherited a database from someone else. It *looks* like there are
probably a lot of unused queries that can be disposed of. Is there an easy
way to tell if a query is being utilized by any other item in the database or
not?

Thanks!

 

[Jerry Whittle]

Rich Fisher's excellent Find and Replace add-in might be just the ticket. If
you register it (one of the best $37 I've ever spent), the cross-reference
report can find what queries use which reports and forms. It's a good way to
find orphans.

http://www.rickworld.com/

 

[Fred]

Or, in Access, select the query on the list and hit View -> Object
Dependencies

 

[Tara]

Thanks to both of you for the tips!