Re: which queries use table X?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ed Robichaud (edrobichaud_at_wdn.com)
Date: 03/15/05 

Date: Tue, 15 Mar 2005 17:50:00 GMT

FMS Access Analyzer will report out all object references and
interdependence (and many other things). I think the retail price is $199
    www.fmsinc.com

-Ed

"OldTymer" <OldTymer@discussions.microsoft.com> wrote in message
news:61B25F79-229D-4D98-A51C-F63E8DF7BF6B@microsoft.com...
> Is there a way to find out which queries refer to a given table?
>
> I have to modify how tables X, Y and Z are used throughout this app. I
> can
> use FIND in the VB Editor to search all Forms and Modules in the whole
> project for a table name -- but what about searching in queries? Or
> reports?
>
> Bonus question: is there an easy way to find the 'dead wood' in a
> project?
> I man things like unused queries, reports, tables, forms, etc. I can see
> that quite a few people have carelessly hacked on this project over the
> years, which makes it harder to "just fix" what I'm working on.
>
> Thanks muchly.
>