How to determine database structure quickly?

[lawpoop]

Hey folks --

I have a project where I'm upgrading a somewhat dated Access project
from a previous developer. Documentation is non-existant and the Access
file itself is somewhat of a mess.

What I would like is some way to easily see objects (tables, queries,
forms, reports) are unused or used, and if used, where. More
specifically

- What table or query each form draws from, if any
- The form navigation system; i.e. what buttons on what forms call up
what other forms
- What tables and queries are not referred to in any form, code, or
query
- Which tables and queries each form, code, and query refer to
- What report are not referred to in any form or code
- What reports are referred to by what code

I have Speed Ferret 4.1, and I can do searches for any object (form,
query, report, table), but I have to do them one by one. It's currently
easier to look up this information by hand, which is what I'm doing
now.

Is there any tool to help me do this automatically?

 

[Douglas J Steele]

Take a look at Total Access Analyzer, from FMS
http://www.fmsinc.com/products/analyzer/index.html