Data Dictionary for Access

[Kim Johnson]

Is there a way to create a data dictionary for tables in a
datbase?

Example: I have 4 different tables in a database.
I want one table that reporesents all 4 tables and their
attributes.
This way users can search by field name and find the table
(s) that the field is available in.
They would also be able to print this out and use it like
a schema.

Any help would be appreciated.

 

[Albert D. Kallal]

By far and away the best thing to do is to print out the ER diagram. This
can be viewed in the tools->relationships window. Not only does this show
all fields, BUT FAR MORE IMPORTANTLY, it also shows the relations between
each table. To just give me a list of fields and tables is rather lousy, and
not much use. However, to give me a nice ER diagram showing the tables,
fields and the relationships between those tables is a zillion time better.

You can also jump right into table design mode while looking at the ER
diagram.


The other thing you can use is the database documenter. It will also produce
a very nice columnar listing of each field in each table (you have play with
the settings, as the default does NOT give a nice columnar listing). You can
even send this report to a word doc.

I am also sure that some must have a small piece of code hanging around that
also does create a table from the field defs, but I think the above two
options is much better.