Looking for comprehensive Object Dependency utility

[GraeagleBill]

In Access 2013, one can obtain Object Dependencies via Database Tools for queries, forms, tables, reports, etc. but not used in general modules. Further, one has to examine each object dependency one at a time. Hopefully, I've characterized the use of the Database Tool correctly.



What I'm in need of is a utility that will give me a report of "where used" (dependency) for each query and table in my DB including use in general modules. I found Allen has something for where fields are used but not a comprehensive report on where queries are used.

For example, as one would expect, query references show up as RecordSource and RowSource within forms, reports, combo's, etc quite regularly and the Object dependency built-in in Access easily finds them. However, many of my general modules, form modules and report modules make use of queries in DAO Recordsets, so those references need to be revealed as well.

Any ideas?

[rpeare]

Are all of your query names explicitly written out in your code?

You can try to write all your code to external files (https://www.tek-tips.com/viewthread.cfm?qid=1386464)

then parse each of the files looking for names your database would recognize. I'm not sure this would be terribly efficient though because you'd have to have some way of recognizing where a name is occurring

i.e. set rst = currentdb.openrecordset("qryTEST")

you'd recognize this by testing the line of code for 'set rst = current'

you'd also have to test for things like dcount, dsum, dlookup if you're using them, in other words have a 'trigger' list just to see if you need to extract a name.

you may also try this:

http://www.utteraccess.com/forum/Rea...-t2021888.html

but this code is only cycling through modules, not code relating to forms etc.

[Minty]

MZTools https://www.mztools.com/v8/download_trial.aspx has a number of useful tools and I believe VTools http://www.skrol29.com/us/vtools.php has a deep search facility, both might help.

I've used MZ Tools for years !