Is there a way to tell where exactly a certain table being used?

I have a lot of queries, reports, modules in a database and I need to rename
a table. Is there a way to get a list of queries, reports and module where
that particular table is being used? So I do not have to check every single
object.
Documenter did not work....
thanks

Rich Fisher's excellent Find and Replace add-in might be just the ticket. It
can change everything related to the table and change them also.

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/
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Irina" wrote:

I have a lot of queries, reports, modules in a database and I need to rename
a table. Is there a way to get a list of queries, reports and module where
that particular table is being used? So I do not have to check every single
object.
Documenter did not work....
thanks