Print list of tables

[Robert]

Is it possible to print a list of tables in a database.

I am using Access XP with Visual Basic 6.0 SP5.

I would like to print the list from either program.

 

[Allen Browne]

There is a built-in documenter on the Tools menu.
In A2007, it's on the Database Tools tab of the ribbon.

If you want something more powerful:
http://www.accessmvp.com/JConrad/accessjunkie/csdtools.html

If you just want a query that returns the local tables:
SELECT MsysObjects.Name FROM MsysObjects
WHERE (([Type] = 1) AND ([Name] Not Like "~*")
AND ([Name] Not Like "MSys*"))
ORDER BY MsysObjects.Name;

Include type 6 for linked tables, and type 4 for ODBC linked tables.