Printout of the table design

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

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
--
rpw


"lavanya" wrote:

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

On Mon, 21 Jun 2004 15:02:20 -0700, "lavanya"
wrote:

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

In article ,
says...
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/AS...jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com