which queries use table X?

From: OldTymer (OldTymer_at_discussions.microsoft.com)
Date: 03/15/05 

Date: Tue, 15 Mar 2005 05:41:01 -0800

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.

Relevant Pages

  • Re: How allow users to modify and create reports?
    ... modify forms and reports. ... > all existing reports, forms, queries and modules read-only. ... I'd prefer to not use user-level security. ...
    (microsoft.public.access.reports)
  • Re: A2007 ADPs
    ... Passthrough queries can be good for complex reports but excerpt for the ... I admit I had forgotten about this feature, not having done much MDB work ... When the schema of the database is not too complexe, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Convert MDB to ADP
    ... I will try to explain what I'm using in access mdb about filter queries ... I have a form where I generate reports, queries, forms and by automation I ... Is it possibel to find any function in SQL server to replace Format, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Linking in Access
    ... Another approach to consider would be to create the front-end, ... queries, forms, reports, then convert it to an .MDE file. ... maybe in a diff DB (diff forms for diff ...
    (microsoft.public.access.gettingstarted)
  • Re: Please help! (Reports and Queries)
    ... By the way MSysTables are hidden system tables. ... that can actually run a query in the applet is Admins. ... still cannot run the queries. ... I need to be able to action a number of queries (& also reports) on my ...
    (microsoft.public.access.queries)