Data Dictionary

  • Thread starter Thread starter T'Kai
  • Start date Start date
T

T'Kai

Does anyone know the code to build a simple data
dictionary? I want to print out the field name, datatype,
and description for each field in every table in the
database.

The built-in documenter offers unnecessary information. I
really need this to be basic information.

Any help will be appreciated.
 
(untested)

dim db as database, td as tabledef, fld as field
set db = currentdb()
for each td in db.tabledefs
debug.print vbcr; td.name
for each fld in td.fields
debug.print vbtab; fld.name
next
next
set db = nothing

Yoiu could also iterate the Properties collection of the Tabledef and Field
objects to display the table & field properties (not just their names). All
those things are documented in online help.

HTH,
TC
 
Back
Top