Tuesday, March 27, 2012

List of tables in Access DB

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.check out this
http://www.aspfaq.com/show.asp?id=2178

"SK" <anonymous@.discussions.microsoft.com> wrote in message
news:5010233F-902E-4610-AC3F-CD054612C27D@.microsoft.com...
> 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.

0 comments:

Post a Comment