Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Plymouth, UK
    Posts
    59

    Unanswered: Print all contents of database

    Is their anyway I can print a list of all tables, queries, forms, macros, modules etc.

    Please help!!!

  2. #2
    Join Date
    Oct 2003
    Location
    Boston, Mass. USA
    Posts
    81
    Try the options under the following:

    Open database > Tools Menu > Analyze

    - Mark

  3. #3
    Join Date
    Jun 2003
    Posts
    76
    You can also query the msysobjects table with a query like this:

    Code:
    SELECT MSysObjects.Name, MSysObjects.Type
    FROM MSysObjects
    WHERE (((MSysObjects.Type)=1 Or (MSysObjects.Type)=5 Or (MSysObjects.Type)=-32768 Or (MSysObjects.Type)=-32764));
    This will pull tables, queries, forms and reports.

Posting Permissions

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