Which query uses that table?

d-fxt · November 15th, 2006, 12:21 AM

G'day from Down Under,

Is there a quick way in MS Access to find out which query uses which table?
Opening each and every query in Design view to see if it refers to a particular table is not feasible when there's hundreds of queries.

Thanks,
d-fxt

vemaju · November 15th, 2006, 03:53 AM

Hi,
In Access 2003 you can use Object Dependencies
Take a shortcut menu in your query or table or any object.
This can be done in database window.
You get Objects that depend on me and Objects that I depend on.

-vemaju

d-fxt · November 15th, 2006, 07:08 PM

Cool.
Thanks vemaju.

Is there a way to get this feature to work with tables linked to other .mdb files?

Cheers,
d-fxt

vemaju · November 17th, 2006, 08:24 AM

Hi,

In my databases this property works great with linked tables as well.

-vemaju