On Tue, 31 May 2005 16:03:34 -0700, "CoachDeb"
wrote:

Here's what I need: a way to find where all fields, tables, forms, queries,
macros, reports, modules, visual basic procedures ... are mentioned. if
Access can create it, I need to know what its source is (macro, table.field,
report, ..), where it's called from, and what other modules call it.

In other words, I need a complete analysis of all relationships NOT defined
as database relationships (linked tables - that's easy). The relationships
I'm looking for are coding relationships because I can't delete or change a
field unless I know where it's being used and what side effects will be
generated by these changes.

Anybody have or know of a free utility or report generator that will do
that? A nice visual/graphical documenter would be outstanding.

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

The last three are not free, but check the websites, I believe that
Rickworld and Speed Ferret have demo versions (variously handicapped).


John W. Vinson[MVP]