Results 1 to 3 of 3
  1. #1
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Printing all Table Names and Fields (Access 2000)

    Is there a way to print out each table name and the data fields / properties for all or each table in an access database? (Similar to the Desc tablename feature in Oracle). I do not want to use screen shots as there are tables with too many datafields that do not show up on one page.
    Thanks for any suggestions.
    Regards,

    Gary
    (It's been a while!)

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Printing all Table Names and Fields (Access 2000)

    Hi Gary,
    Try Tools-Analyze-Documenter
    there are various options for the level of detail you get.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Printing all Table Names and Fields (Access 2000)

    Rory,

    Thanks for the information. It extracted the data that I was trying to get.

    Do you know of a way to select only tables containing a particular name or part of a name. Similar to
    Select tablename from all tables where tablename like..... ??
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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