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]