Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Get table names from database

Author  Topic 

Code128
Starting Member

3 Posts

Posted - 2011-10-25 : 12:28:29
Is there a method to get the name of all the tables in an Access Database? I'm guessing there isn't a simple select statement but I would like to return a list of the table names in the database.

edit: moved to proper forum

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-10-25 : 18:05:03
I found this: http://nm1m.blogspot.com/2005/06/ms-access-list-table-names.html

There's a setting in Access to show system objects, can't remember where it is though. There's also a VBA method using the TableDefs collection.
Go to Top of Page
   

- Advertisement -