Retrieve Table's field properties

[Sheila Shaver]

I am a fairly advanced Access user, but an amateur for programming. I have
been tasked to create a "Database Dictionary" which will include
approximately 5000 tables with 4-150 fields in each table. I need to extract
all the field properties to populate a "denormalized" table. My
"denormalized" table includes fields: (1)DatabaseName (2)TableName
(3)FieldName (4)DataType (5)Size (6)AllowZeroLength (7)Attributes, etc. with
a field for each possible field property from all outside databases. There
has to be an easier way than using the Documenter, analyzing with Excel and
having to cut & paste from there. All tips are more than welcome.

 

[Allen Browne]

Examine the Fields of the TableDef, and the Properites of each field.

Here's a basic example that loops through the fields of a table, showing the
name, type, size, and description:
http://allenbrowne.com/func-06.html

You can adapt it to examine the other properties.