Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2004
    Posts
    77

    Post Unanswered: Retrieving the names of tables

    Hi ppl,

    I've got another question for you all. How do i retrieve the names of the tables I have using query?

  2. #2
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: Retrieving the names of tables

    You can't. Schema information can be retrieved only by using DAO's table collection, or using ADO's OpenSchema() or ADOX functionality.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  3. #3
    Join Date
    Mar 2004
    Posts
    77

    but...

    if do not use query to retrieve the table names, is there anyway i can retrieve the names? Sorry, but i'm just a beginner at Access development.

  4. #4
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: but...

    You need to use VBA in either DAO or ADO mode.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Copy and past the next statement in a new Query and run it:


    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;


  6. #6
    Join Date
    Mar 2004
    Posts
    77

    THANKS!!!

    thank you hammbakka. the code works wonderfully!!! thank DoktorBlue
    for your information also.

  7. #7
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: THANKS!!!

    thank you hammbakka, too. I never dared to use these system tables.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  8. #8
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    No problem, main thing it functions.
    Have nice day

Posting Permissions

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