Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    3

    Unanswered: Database statistics?

    Is there a way to easily find out some basic information about a database? For example:

    - Which tables or queries are referenced by other queries or by forms (dependencies list).

    - How much space is each table using.

    Thanks.

  2. #2
    Join Date
    May 2002
    Location
    London
    Posts
    87
    I have some code for looking at the hierachy of objects in a database

    The Procedure 'QueryStructure' Looks for to find references to any query or table in all queries tables forms and modules. It doen't look in reports as yet and will think a reference to 'qry11' is also a ref to 'qry1'

    There are also a few other bits and pieces which may be of use.

    NB 'QueryStructure' only works with 2000 or later due to references to AllForms and AllModules
    Attached Files Attached Files

Posting Permissions

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