in message:
I would like to print selective information about a table. Will this
utility or another like it print selective info?
Where can I download this?
Hi Dave,
My John Viescas Table Documentor add-in has not been placed on a
web site yet. I am awaiting word back from John on the possibility
of him posting it on his site. For now, I am e-mailing the file to
anyone who wants a copy.
What exactly do you mean by "selective" info about a table?
My 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?
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.
If you are uncomfortable about posting a munged e-mail address, post
back and I will let you know how to contact me.
The add-in will do all the tables in the database, not selective tables. If you are
looking at only certain information (or more than what mine kicks out)
you might want to just use the built in Documentor for this:
Tools | Analyze | Documentor
You could then specify exactly what you wish to see and what tables.
Here are a few more options for you as well:
1. David Hare-Scott has also written a simple table documentor. You can
download it here:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hare-Scott,David
2. Armen Stein has something here as well:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
(Look for Data Dictionary Report Utility)
3. MVP Allen Browne has some TableInfo code here:
http://allenbrowne.com/func-06.html
4. FMS has utilities that can do this as well:
http://www.fmsinc.com/
Hope that gives you some ideas,
