Identify fields in a DB

G

Greg

I have built a database using Access 2000 with about 15 tables.
I have experimented with the Access 2000 TOOLS>ANALYZE>DOCUMENTER and found
it somewhat helpful.
However what I would like to see is a list of all fields in the entire DB
followed by the tables they are contained within.
I am new and tried to normalize and do things correctly but have still
probably duplicated data unnecessarily.
Does anyone know if there is a way to get a list of fields across the entire
data base rather than by table, so I can review what I have done.
 
K

KARL DEWEY

Select all tables.
Options - Names, Data Types, Sizes and Properties
Run it and then click on the "W" icon to save as a Word document - saves as
a RTF file. Then save as Plain Text.
Use Excel to open. Save as Excel file. Highlight column A. Replace
"Table: " (there is a space after the colon).
Insert new column. In new column A enter =IF(B2="",A1,B2)
Autofill. Copy and Paste Special - Values.
Delete column B.
 
G

Greg

Mr. Dewey,
I initially thought i understood but I do not know how to do what you
suggested. How do I "select all tables"? And then how do I "run options -
Names, DataTypes, Sizes and Properties.
I really feel incompetent asking questions that are probably obvious to most
people.
Thank You,
Greg
 
Top