Get table names fro an MS-Access DB

[Byourself]

Is there a way to get the table names from an MS-Access database by SQL only?

I know that in Oracle, for instance, that will be accomplish easily (SELECT table_name from tabs...)

Thanks,
Shay
---------------
"We'll never give up, it's no use" (Blink 182)

 

[GabeC]

Try this statement

SELECT * from MSysObjects where type = 1


This will return system tables also. From what I see the Flags column is alway 0 for tables you created. You should check this too.

Thanks,

Gabe