Determining what forms and reports use what queries

[Kyle]

I've inherited a database that's been around for seven years and been
worked on by God-knows how many people who have all created queries and
reports and forms over the years that served a purpose at the time, but
now, who knows? I would like to be able to easily figure out what
queries are used to generate what forms and reports without having to
open each form or report and look at its properties.

Is there some way of seeing the "relationship" (I hesitate to use the
term) between forms or reports and queries, perhaps a way of printing
out form and report names sorted by query?

 

[Albert D.Kallal]

access 2003 has this feature built in.

All you have to do is right click on a report, and select "object
dependences".
(or right click on a query)

(access will then ask your permission to turn on track autoname correct.).

I suggest after you are done..to turn that feature off...

tools->options->General tab

un-check the "name autocorrect" box the
"Track name Autocorrect info"

Note that while this will show what forms, reports etc. use the query, there
is really NO way to tell what code uses the query.

you code might go

strQueryName = "qryTest"

currentdb.Execute strquery

As you can see, code that uses the queries is often resolved at runtime, and
the ONLY way to thus know is to read all of the code.

There might even be code that lets a user "select" a query from a drop down
box etc...and again, this is NOT resolved until runtime.

However, the track auto name feature in a2003 is rather a nice touch..and is
a good starting point...

 

[Larry Daugherty]

Easy? No.

You might try Find and Replace a shareware addin from Rick Fisher at
www.rickworld.com It will any reference to any term. It requires
that you enter the search term manually.

I think that Speed Ferret from Black Moshannon, a commercial product,
will do the same.

HTH

 

[Ron Hinds]

Total Access Detective by FMS Inc. (http://www.fmsinc.com) will do what you
are asking.