Thread: Data Dictionary
View Single Post
  #4  
Old January 28th, 2005, 03:10 AM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default

I created an Access Add-In called the "John Viescas Table Documentor"
that does exactly this. It is even easier to use than the built-in Access
Documentor and creates a slick report that will list each table (including
linked ones) and their field properties in an easy-to-read format. I recently
finished Version 2.0 of the add-in. This version even works on MDE files.

Once installed (takes less than a minute) all you have to do is
Tools | Add-Ins | John Viescas Table Documentor. Poof!
After a few seconds a slick report is displayed on the screen. Easy as pie!

I am awaiting word back from John about the possibility of having him post
it on his web site where anyone can download it. In the meantime, I do not
believe he would have a problem if I sent you a copy. If you do wish to have
a copy please let me know where you would like it sent to (please mung the
e-mail address so you won't get spammed!). There is one version for Access
97 and one for 2000 which works with Access 2000, 2002, and 2003.
I will need to know which version you need.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Cindy H" wrote in message ...
Hi,



I need to create a list of all the data elements used in my project. The
list needs to include the descriptions that I typed into the description
column of the table design view. I've tried the Tools-Analyze-Documenter,
but it does not show the description column data. Any ideas how to extract
the description so I don't have to retype all this info to create a data
element dictionary?



Thanks, Cindy H