how do i create a layout from an Access DB?

J

joseph

i need to create a layout from a 50 column access file and don't want to type
them all out. I want name, start pos, end pos, lenght and data type. any
thoughts?
 
R

Rick B

Tools/Analyze/Documenter.

But, if you have a table with 50 columns, then it sounds like you do not
have a normalized database. Relational databases should have small related
tables. At the very largest you should have about 30 fields in any one
table.
 
R

Rick B

Ummm. One more thing. You say starting position, length, etc. Access is
NOT a spreadsheet. It is a database. There is no "starting position" for a
database field. There are fields and they have maximum sizes. The order
and how much of a field you choose to display is all up to you.
 
Top