Retrieve Table's field properties

S

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limited field properties? 4
Problems opening workspaces to add tables/fields to secured access 0
Obtain Field Properties 7
print out Table Description Property (and Field Descriptions) 2
Creating combobox in Linked Table through VBA 4
How to get each table's first line of record and write into excel? 3
Split delimited field data TWICE to populate specific other fields 3
Referring to Macrobutton Field properties without selecting them 3

Top