Listing Tables in Access

Results 1 to 4 of 4

Thread: Listing Tables in Access

  1. #1
    Join Date
    Dec 1969
    Posts
    29

    Default Listing Tables in Access

    Does anyone know if there is a way to list all the tables<BR>in a MS Access database?

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: Listing Tables in Access

    Oh yes, there is a way. :)<BR><BR>Check out this article at 4Guys:<BR><BR>Listing the Tables in an Access MDB Database using ASP<BR>http://www.4guysfromrolla.com/webtech/092298-2.shtml<BR><BR>Happy Programming!

  3. #3
    Join Date
    Dec 1969
    Posts
    9

    Default RE: Listing Tables in Access

    *<BR> Yes!that prog.for listing the tables in a database was pretty useful.But how does one list the fields(fieldnames) and their corresponding datatypes of the table?

  4. #4
    Join Date
    Dec 1969
    Posts
    11

    Default RE: Listing Tables in Access

    No problem also<BR>set rec = con.OpenScema(adSchemaColumns, Array(empty,empty, "YourTableName"))


Posting Permissions

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