Access Documenter

[tpearo]

Does anyone know if there is a utility or someway to accurately document and print out all the tables, queries, forms, macros, etc. in a Access Database and all their assocications.... for example, what tables are involved in a query. Relations would be good too.

Any ideas.

Tp

 

[RoyVidar]

I'd take a look at jrbarnett's documenter. There's a link to their site, at least from the link page of the Access VBA forum (forum705).

The "what tables are involved in a query" thingie, is perhaps a tad more complex - are you also after whatever dynamic SQL "floating" around in rowsources, recordsources and VBA too? - just a tad more work...

The topic has been discussed lot's of times, you should be able to find something through a search.

BTW - here's a faq on documenting Macros faq705-5796 - though you'd get the same info from the documenter.

Roy-Vidar