list all tables

  • Thread starter Thread starter Finn Fonnaas
  • Start date Start date
Simplest to query the system table directly:

SELECT MsysObjects.Name FROM MsysObjects
WHERE (([Type] = 1) AND ([Name] Not Like "~*")
AND ([Name] Not Like "MSys*"))
ORDER BY MsysObjects.Name;

Alternatively, loop through the TableDefs collection of dbEngine(0)(0) in
DAO, or the Tables of the Catalog in ADOX (removing Views, etc.)
 
You must log in or register to reply here.

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

Filtering a table by using criteria in another table 1
Counting multiple memberships 1
specified field [equipment] could refer to more than one table listed in FROM clause of SQL statemen 1
How to export table from outlook into ms access table? 0
VBA - retrieve data on last create named range from previous inserted named range 0
Individuals who have not taken course 3
Print a list of tables in MS Access 2007 2
Importing and merging tables 0

Back
Top