Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    india
    Posts
    41

    Unanswered: command to see Database tables in MS-Access

    Is there any command to know the user tables in a database ?

    In MSSQL Server we can use select * from sysobjects where type='u'
    to see the user tables in the database.

    Like this is there any query we can execute to find the user tables in MSACCES.

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    Select * from MSysObjects

    Will list all system objects, I can't remember the criteria for tables, you will need to look at it to determine what that is.
    S-

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Here is the SELECT Statement to select only tables
    4= for Linked Tables
    1= for Acce$$ Tables



    SELECT MSysObjects.Name, MSysObjects.Flags, MSysObjects.Type
    FROM MSysObjects
    WHERE (((MSysObjects.Name)<>'MSysObjekts') AND ((MSysObjects.Flags)<>-2147483648 And (MSysObjects.Flags)<>2 And (MSysObjects.Flags)<>-2147483645) AND ((MSysObjects.Type) In (1,4)))
    ORDER BY MSysObjects.Name;

Posting Permissions

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