List of tables in Access DB

[Guest]

Hi !
I wanna find out the list of tables in my Access DB file. But when i try to open it through the following query

" SELECT Name FROM MSysObjects WHERE type=1 and flags=0; "

i get this error in ASP.Net

" no read permission on 'MSysObjects'. "

Can anyone help me to fix this error or some alternative to find the list of tables in my access.mdb
Please reply at the earliest.

 

[Joe Gass]

check out this
http://www.aspfaq.com/show.asp?id=2178

Hi !
I wanna find out the list of tables in my Access DB file. But when i try

to open it through the following query