Create list of dependencies and dependants

[Helge V. Larsen]

I have with some luck tried to program some VBA that writes a text file with
all dependencies and dependants for all tables and queries (should be
extended with forms and reports).

I am able to find the top level dependencies/dependants only as well as all
levels (by iteration).

For each dependency/dependant I have with no success tried to list whether
it is a relation, or used in a query, or a LookUp-table used in a table
design (probably there are more cases).

I have found out that some queries that function correctly will crash access
when asking for dependencies/dependants. The situation can NOT be trapped by
an "On Error" statement !

Has someone already programmed a facility like the one described above ?
(It is a bit too hard programming for me.)

I am using MS Access 2003 on XP Professional vers. 2002 SP2

 

[Guest]

Rich Fisher's excellent Find and Replace add-in might be just the ticket. If
you register it (one of the best $37 I've ever spent), the cross-reference
report can find what queries use which reports and forms. It's a good way to
find orphans.

http://www.rickworld.com/