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