Results 1 to 7 of 7
  1. #1
    Xty
    Guest

    printing a list of tables

    Access 2000 v9.0 how do i print a list of all of the tables and/or queries in my database?

  2. #2
    2 Star Lounger
    Join Date
    May 2001
    Location
    Wichita, Kansas, USA
    Posts
    177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: printing a list of tables

    Have you tried using the documenter? (under Tools)

  3. #3
    Xty
    Guest

    Re: printing a list of tables

    Yes, however, in short this seems to miss the mark on what i'm trying to accomplish...i.e., it takes an unusually long time as it 'examines' each of the tables in my database (100+ tables). even when i go into tools/analyze/documenter/options and chose 'nothing' for "include for...table/fields/indexes" and then it prints a table name per page rather than a simple list of ALL of the tables in the database.

  4. #4
    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 a list of tables

    You can get a simple list of tables using this SQL:
    SELECT Name from MSysObjects WHERE Type = 1
    You can get a list of queries by changing Type to 5.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Xty
    Guest

    Re: printing a list of tables

    where/how do i do this?

  6. #6
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: printing a list of tables

    Create a NEW query. Switch to SQL view and insert the parameters Rory gave. Switch to datasheet view for the results.

  7. #7
    Xty
    Guest

    Re: printing a list of tables

    Fantastic...what can i add to the sql statement to also get the description?

Posting Permissions

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