Print a list of tables

  • Thread starter Thread starter Benn Vosloo
  • Start date Start date
B

Benn Vosloo

How can I print a list of all the table names, query names
etc oa an access database?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Sorting and grouping using multiple tables 0
MS Access: How can I print the design view of a table? 2
Counting multiple memberships 1
Question ref look up table 0
How do I print a list of database object names? 3
VBA - retrieve data on last create named range from previous inserted named range 0
Manage Database Properties/Database Documenter 2
Copy list of tables to Excel 5

Back
Top