"Where used" Analysis to find all occurrences of fields, tables, e

C

CoachDeb

I just inherited a poorly designed database and have been assigned the task
of cleaning it up, properly normalizing tables with 30 fields (!) in them -
yes, welcome to my nightmare.

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.

Thanks,

Deb
 
J

John Vinson

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top