Print a list of tables

[Benn Vosloo]

How can I print a list of all the table names, query names
etc oa an access database?

 

[Alex Dybenko]

you can use system MSysObjects table, Name is object name, Type - object
type

 

[Allen Browne]

There is a built-in documenter:
Tools | Analyze | Document

You could do it with a query:
SELECT MsysObjects.Type, MsysObjects.Name FROM MsysObjects
WHERE ([Name] Not Like '~*') AND ([Name] Not Like 'MSys*')
ORDER BY Type, Name;

Interpret type like this:
1 = table
5 = query
-32768 = form
-32764 = report
-32761 = module

If you need to list the fields within a table, see:
http://allenbrowne.com/func-06.html