Microsoft Access field listing

April 28, 2005 2:36 PM

Isn't there some simple way to list out all the fields in all the tables in an MS Access database?

I'm running Access 2000, and have just taken on a project that involves analysis of data in a bunch of tables. The database came with just the tables, and I have to create links between them for queries and all that. My question is, there's a lot of tables and many of them have lots of fields - isn't there some way that I could just get a listing of all the fields in the tables that I could print out and start to use to map relationships between fields in different tables?

posted by jasper411 to Computers & Internet (3 answers total)

Best answer: Try

Tools>Analyze>Documenter

It'll walk you through a quick wizard that'll give you pithy stats on all of your tables.
posted by COBRA! at 2:45 PM on April 28, 2005

Under Sybase or MS SQL Sever you'd query the system tables:

select a.name, b.name from systables a, syscolumns b where a.id = b.id and a.type = "U" order by a.name, b.colid

I'm sure there's an analogous query for Access.

Under sybase, if you wanted to see (defined) elationshops, you call sysdepends:

exec sysdepends "table1", "table2"
posted by orthogonality at 2:56 PM on April 28, 2005

If you have Visio you can go one step further and map out your database with ease. (Visio rocks)
posted by angry modem at 3:08 PM on April 28, 2005