MDB FIELDS ...

[Guest]

Have always wanted to gen a script, or ??, to print a tabular list of table
fields and all properties, with field and property in rows. Got any simple
methods to offer??

 

[Albert D. Kallal]

The built in documenter will do this for you....


tools->analyse->documenter.

select the table tab, and click on the options tab

uncheck the first 3 settings (include for table),

the 2nd set of options, chose name, data types, and sizes.

and for the 3rd set of options choose "nothing" option.

If you don't choose the above options..then you NOT get a column list....

 

[John W. Vinson]

Have always wanted to gen a script, or ??, to print a tabular list of table
fields and all properties, with field and property in rows. Got any simple
methods to offer??

In addition to the Documenter suggested by Albert, there are some good
third-party tools to do this. Check out

http://www.accessmvp.com/JConrad/accessjunkie/doctable.html


John W. Vinson [MVP]