in message:
I am attempting to use the tools- analyze- documenter feature in Access
2000. I am running win 2000 OS.
When I select the Tables tab in the documenter window and then select
several tables to print or review I only get the table name on the first
table selected while reviewing on my monitor.
When I print I get no table names on the hard copy even for the first table
selected.
The options selected are: Include for tables- " Properties" / Include
for fields- "Names,data types, sizes" / Include for indexes- "nothing"
Does anyone know why the table names will not print? I thought I was
following "HELP' description as written.
Hi Greg,
I'm not sure why you are getting that error with the Documentor.
I have not run into that issue myself. Listed below are a few other options
for you to document the tables.:
1. 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!
The report will list each Field Name, Description, Type, Length, and which
field(s) compose the Primary Key.
The display output will be something like this:
Table: tblVendors
Field Name: Description Type Length Primary
VendorID ID Field Autonumber 4 X
VendorName Vendor's Name Text 50
etc...
Will this work for you?
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.
2. David Hare-Scott has also written a simple table documenter. You can
download it here:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hare-Scott,David
3. Armen Stein has something here as well:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
(Look for Data Dictionary Report Utility)
4. MVP Allen Browne has some TableInfo code here:
http://allenbrowne.com/func-06.html
5. FMS has utilities that can do this as well:
http://www.fmsinc.com/
Hope that gives you some ideas,
