Re: which queries use table X?

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

From: Rick B (Anonymous)
Date: 03/15/05 

Date: Tue, 15 Mar 2005 08:22:13 -0600

This is asked and answered often. Do a search. Try "unused".

Rick B

"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.
>