List of tables in Access DB

Discussion in 'ASP .Net' started by =?Utf-8?B?U0s=?=, Dec 17, 2003.

  1. 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.
     
    =?Utf-8?B?U0s=?=, Dec 17, 2003
    #1
    1. Advertising

  2. =?Utf-8?B?U0s=?=

    Joe Gass Guest

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

    "SK" <> wrote in message
    news:...
    > 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, Dec 17, 2003
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?TWFuaXNoIFNhd2ppYW5p?=

    Adding records to MS Access 97 Tables using ASP.net

    =?Utf-8?B?TWFuaXNoIFNhd2ppYW5p?=, Feb 4, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    429
    =?Utf-8?B?TWFuaXNoIFNhd2ppYW5p?=
    Feb 4, 2005
  2. roni
    Replies:
    0
    Views:
    516
  3. Peter Bassett
    Replies:
    3
    Views:
    939
    Augustus
    Aug 15, 2003
  4. Otuatail

    Tables within tables

    Otuatail, Jul 31, 2004, in forum: HTML
    Replies:
    7
    Views:
    505
  5. Chris Brat
    Replies:
    5
    Views:
    700
    =?iso-8859-1?q?Luis_M._Gonz=E1lez?=
    Aug 22, 2006
Loading...

Share This Page