DataBase Analyzer

The DataBase Analyzer is a utility program designed to help you map the internal structure (or schema) of your Jet databases.  These mappings can help you with you programming tasks and with the documentation of your programs.  The program will print the information about the following objects in your databases:

Tables - Including field and index information

Queries

Relations

   File

   Analyze Database


File

The file menu initially shows two choices, Open Database and Exit.  Exit will close any open database and take you out of the program.

The Open Database option will present you with a "File Open" dialog that will allow you to choose the database which you wish to analyze.  When you choose a database, the program opens the database, then changes the caption of the main form to show the database which is currently open.  Also, the Open Database option of the File menu will change to Close Database.  This prevents you from having more than one database open at a time.

If you select Close Database from the File menu, the program will close the currently open database, change the form caption back to its initial setting, and show the Open Database menu choice again.


Analyze Database

This menu option brings up the object selection window, where you can select which tables and queries will be included in the analysis.


Object Selection

The object selection window allows you to control which database objects will be printed by the program.  The window contains a list of all non-system tables, and a list of queries.  You may select any or all tables and queries to be printed.  You may also select to have the table relations defined in the database printed.

   Query Selection List

   Print Table Relations

   Print General Database Information

   Deselect All Tables

   Deselect All Queries

   Exit

   Run Analysis

   Select All Queries

   Select All Tables

   Table Selection List


List of Available Queries

This list will show you any queries which are defined in the currently open database.  You may select queries to be included by in the printout by clicking on them with the mouse.  The list supports multiple selections.  Therefore, you can select (or deselect) queries by holding down the Ctrl key and clicking the mouse.  You can also select a group of queries by clicking on the first item to select, then holding down the Shift key and clicking on a second item.  All items in between will be selected.

You can select all available queries with the "Select All Queries" button.


Print Table Relations

This check box determines whether or not relationships defined in the database will be printed.  If chosen, the program will print the following information for each relationship:

Primary Table

Primary Field

Related Table

Related Field

Support of cascade functions

Enforcement of referential integrity


Print General Database Information

This check box determines whether or not general information about the database will be printed.  This information is beyond the name of the database and the version of Jet used.  This option is inactive in the current version of the program.


Deselect All Tables

Unmarks all tables in the selection list.  After this button is pushed, no tables will be selected for analysis.


Deselect All Queries

Unmarks all queries.  After this button is pressed, no queries will be selected for analysis.


Return to the Main Menu

This button exits the Object Selection window and returns you to the main menu.


Print the selected database information

This command button cause the program to print out the database information for all selected database objects.


Select All Queries

This button will cause all available queries to be selected for analysis.


Select All Tables

This button will cause all available tables to be selected for analysis.


List of Available Tables

This list will show you any tables which are defined in the currently open database.  You may select tables to be included by in the printout by clicking on them with the mouse.  The list supports multiple selections.  Therefore, you can select (or deselect) tables by holding down the Ctrl key and clicking the mouse.  You can also select a group of tables by clicking on the first item to select, then holding down the Shift key and clicking on a second item.  All items in between will be selected.

You can select all available tables with the "Select All Tables" button.


Jet Databases
Jet databases (also known as Access databases) are the native format of databases used by the Microsoft Jet engine.  The files typically have the extension MDB.