in message:
hi, how t print out the tables strucure:
Acct table:
Field Name Length Type
Title 5 Integer
FirstName 30 String
You can use the built-in Access Documentor
(Tools | Analyze | Documentor) to get a huge list of just about everything
you ever wanted to know about the database. At the same time, you can
keep the logging and paper manufacturing industry going strong in Oregon!
Depending upon the options you select, you could fell several trees.
I have another option for you as well.
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.
