Find all references to a query in it's MS Access DB

Discussion in 'Microsoft Access Queries' started by RWM, Apr 13, 2004.

  1. RWM

    RWM Guest

    I need a module that when run would provide a list of all
    the objects (reports, forms, other queries,etc.) that
    reference that query in the MS Access DB. Do you know of
    one ?
     
    RWM, Apr 13, 2004
    #1
    1. Advertisements

  2. RWM

    Chris2 Guest

    "RWM" <> wrote in message
    news:1ba7101c42106$6ab60290$...
    > I need a module that when run would provide a list of all
    > the objects (reports, forms, other queries,etc.) that
    > reference that query in the MS Access DB. Do you know of
    > one ?



    RWM,

    The short answer:

    FMS Software writes a 3rd Party product that purports to handle this, but
    I've never used it, so I'm not sure how well it works.

    Or . . . write a VBA module that iterates through the appropriate
    properties (ControlSource, etc.) of every Form and Report, and every control
    on every Form and Report, and through the SQL properties of all QueryDefs,
    keeping an accumulative list of hits whenever the search runs across a
    QueryDef name.


    Sincerely,

    Chris O.
     
    Chris2, Apr 13, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest
    Replies:
    11
    Views:
    293
    Tom Ellison
    Feb 6, 2006
  2. quaddawg via AccessMonster.com

    diagnosing query that references user imputed dates from form

    quaddawg via AccessMonster.com, May 25, 2006, in forum: Microsoft Access Queries
    Replies:
    4
    Views:
    153
    quaddawg via AccessMonster.com
    May 26, 2006
  3. Rolf Rosenquist

    Double references in a query

    Rolf Rosenquist, Jul 29, 2006, in forum: Microsoft Access Queries
    Replies:
    3
    Views:
    143
    Rolf Rosenquist
    Jul 29, 2006
  4. Guest
    Replies:
    8
    Views:
    198
    iliace
    Nov 12, 2006
  5. Jason Lopez

    Query references table for comparison

    Jason Lopez, Oct 8, 2008, in forum: Microsoft Access Queries
    Replies:
    3
    Views:
    131
    Jason Lopez
    Oct 9, 2008
Loading...

Share This Page