Access db

Results 1 to 2 of 2

Thread: Access db

  1. #1
    Yngvar Guest

    Default Access db

    Is it posible to list all available tabels in a access database with a asp page...

  2. #2
    Eddie Campbell Guest

    Default RE: Access db

    Yes, like this<BR><BR>You query the hidden Access table called MsysObjects which lists all the objects in the database. Type 1 denotes a table. <BR><BR>"Select Name From MsysObjects Where Type=1 ORDER By Name" <BR><BR>You may need to grant permissions to the MsysObjectTable from within Access.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts