Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    BC Canada
    Posts
    61

    Unanswered: MetaData in Access

    Basically, I'd like to query an Access database, find out all the tables it contains, then be able to query each table to figure out what fields are in there, the comments in each field, the order the fields are displayed in an Access grid.


    is it possible?

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

    Re: MetaData in Access

    You will have to use DAO or ADO.

    DAO: TableDefs & QueryDefs
    ADO: OpenSchema()
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

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