Documenting a Database

[TotheRiver]

I have a database created by someone else. What is the easiest way to document where the tables, queries, forms and reports go to and where they come from? Is there an add-in out there that will create a report in flowchart format? i have not found the documenter under the tools/analyzer menu not user friendly.
Thanks
Brian

 

[riny]

There are no shortcuts.

The extravagance is mostly in the queries.
Running down the queries that feed reports and forms is probably not an overburdensome excercise (surely not all that many).
An idea is to replace each with the sql format.
After that, change all query names to "whatever old", any form or report that crashes after that was missed.
Having eliminated queries, you have the essential parts left.

hth
cheers
Riny