Reverse engineering

[Tuesday]

I have to document an Access 97 that has grown like wild blackberries.
The database's creator has left us no documentation at all and I would like
Visio to extract as much information as possible.

So far I have extracted a good UML of the tables.

Currently I am doing screen dumps of the forms to show what the screens look
like - then pasting them into Visio.

What else can I do?

Can I extract the queries, forms, reports, macros and modules also - and
save and print these out from Visio?

Please advise.

 

[Al Edlund]

As I remember there was a "database documenter" with Access. I don't
remember what version it came in at but it dumped all of it to a (I believe)
a Word doc.
Al

 

[Tuesday]

Thanks Al,

I have been testing the Access Documenter more since your suggestion.

Initially I was overwhelemed by its detail and lack of friendly graphical
interface.

Now I am using documenter to produce output for most items.

If the output (say one screen) can be neatly copied to Visio on one page -
then I need look no further.

For longer output, I intially do a one-page screen dump and copy to a new
page in Visio - just to give the output a place in my Visio file - but I also
save the documenter information as a Rich Text Format file which I will also
refer to.

Thank you,

Tuesday