Printout of the table design

[lavanya]

I use access 2000. Is there any way to print the design
structure of a table, I don't want a printout of the data
structure ?
by the design of the table I mean need a printout of the
field names and variable types for all the fields in the
table.
Any ideas appreciated

 

[rpw]

I have A2003 so I don't know if this is available in A2000. Click on: Tools/Analyze/Documenter. The reports lists all the criteria for each table by field.

hth

 

[John Vinson]

I use access 2000. Is there any way to print the design
structure of a table, I don't want a printout of the data
structure ?
by the design of the table I mean need a printout of the
field names and variable types for all the fields in the
table.
Any ideas appreciated

Tools... Analyze... Documenter.

Check the options - by default it prints out a whole LOT of stuff, you
will probably want to trim it back.

 

[Armen Stein]

I use access 2000. Is there any way to print the design
structure of a table, I don't want a printout of the data
structure ?
by the design of the table I mean need a printout of the
field names and variable types for all the fields in the
table.
Any ideas appreciated

Hi,

On our web site, we have a free download that prints a simple data
dictionary of tables and fields, including the information you want to
display. It's much more concise that the built-in Access reports.
You can get it at http://www.jstreettech.com/Downloads.asp. It's called
Data Dictionary Report Utility.

Hope this helps,

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com