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
 SQL Server 2000 Forums
 Transact-SQL (2000)
 select * from sysobjects equivalent in Access

Author  Topic 

bdubyah57
Starting Member

3 Posts

Posted - 2004-11-10 : 18:35:43
I use SQL Server daily. It's no problem using SELECT to return all of the user created table names in a SQL server database.
SELECT * from sysobjects where xtype = 'u'

Does anyone know an equivalent statement in Access that would return all of the table names from a .mdb file?

Thanks,
Brian

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-11-10 : 18:37:28
Please do not post the same question in multiple forums:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=42469

Tara
Go to Top of Page
   

- Advertisement -