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