table names in MS Access

[Anon]

i am connecting to a MS Access database in my php script, but i am having problems finding a way to get a list of all the table name in that database. i am not using the normal odbc and dsn way, sense that will not work for what i am trying to accomplish. so odbc_tables is out of the question. i am trying to find some sort of sql query i can do i the database to return a list of tables. thanks for the help.

[Anon]

What are you using then, if your are not using ODBC?

[Anon]

well, i am using the com function to create an ADODB connection to the access database. that is because i need this program to be able to connect to databases without having a system dsn. if anybody could tell me if there is a better way to do this, or if u know how to get a list of table names out of access i would be greatly appreciative.

p.s. i have already tried selecting 'Name' from MSysObjects, but apparently read access is denied from my scripts. any help on this idea would be great

[Anon]

Hi, i reaklly dont like very much ODBC, but try it out. :) Ill send you zip with php lib that i wrote to access any DSN via ODBC. e-mail me. bye4now