list of tables with field names

[Guest]

is there a way to run a query or something that shows me all the tables in
my database and the fields associated with the tables for example

tables
table1
table2
table3

this would be the report

table1 field1
table1 field2
table1 field3
table1 field4
table2 field1
table2 field2
table3 field1
table3 field2
table3 field3

 

[Guest]

Looks like O'Reilly has a solution...
http://labs.oreilly.com/stats/detail.xqy?fpi=0596006780

If you don't have the book, an easy solution to view the columns would be to
use the Documenter...

Select Tools --> Analyze --> Documenter.

Select the "Tables" tab, and then select the tables you want to look into.

geebee

 

[Duane Hookom]

If you use the Documenter you might be interested in this article
http://www.access.hookom.net/Documenter/.