how do i create a layout from an Access DB?

[Guest]

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?

 

[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.

 

[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.

 

[Joseph Meehan]

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?

What do you mean, create a layout?

Access is a database. The tables only store data, not fonts, colors
sizes locations etc. just data.

The data can be displayed in various orders on forms and reports.

Also 50 fields sounds like a poor table design. Let's get the basic
table structure straight first.