Re: which queries use table X?
From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 03/15/05
- Next message: tw: "Re: newbee needs help"
- Previous message: John Vinson: "Re: field data problem"
- In reply to: OldTymer: "which queries use table X?"
- Next in thread: OldTymer: "Re: which queries use table X?"
- Reply: OldTymer: "Re: which queries use table X?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Mar 2005 10:48:18 -0700
On Tue, 15 Mar 2005 05:41:01 -0800, "OldTymer"
<OldTymer@discussions.microsoft.com> wrote:
>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.
There are several tools that have been written by third parties to do
this. In increasing order of power (and price) consider:
Freeware: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com
John W. Vinson[MVP]
- Next message: tw: "Re: newbee needs help"
- Previous message: John Vinson: "Re: field data problem"
- In reply to: OldTymer: "which queries use table X?"
- Next in thread: OldTymer: "Re: which queries use table X?"
- Reply: OldTymer: "Re: which queries use table X?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
