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

  • Thread starter Thread starter RWM
  • Start date Start date
R

RWM

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 said:
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 ?
Click to expand...


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.
 
Back
Top