Copyright: Build 2.01.00 941021 MIKETU


 Microsoft Access Structure Wizard

Copyright Information

Support Policy

Overview

  About the Structure Wizard

Installation Instructions

  Installing the Structure Wizard

  Uninstalling the Structure Wizard


Overview

What is the Structure Wizard?

The Database Structure Wizard is a tool to assist you in documenting and troubleshooting Microsoft Access database applications. It generates tables that detail the organization, structure, and settings of your Microsoft Access database files.

The Database Structure Wizard is an updated and improved version of the Database Analyzer utility included in Microsoft Access version 1.x. It features improved customization and flexibility and takes advantage of many new features found in Microsoft Access version 2.0.

It is important to note that the Database Structure Wizard is not a full-featured reporting tool; sample reports are provided only as examples of how you might organize and present the data collected by the Database Structure Wizard. The wizard's main function is to provide you with raw data about your database files that you can use to create custom reports.

How does the Structure Wizard work?

The Structure Wizard relies heavily on Data Access Object technology introduced in Version 2.0 of Microsoft Access.  With the exception of macros and modules, all analysis functions are performed using DAO.

 The developer tells the Structure Wizard which database objects to analyze.

 The developer tells the Structure Wizard which properties to analyze.  If no selections are made, a default selection of properties is used.

 The developer tells the Structure Wizard where to write the output tables.  If no destination is provided, a default location is used.

 The Structure Wizard goes to work.  It creates the output tables and then fills the tables with the requested information.

 The Structure Wizard reports any errors which were encountered, and then terminates.

At this point, the database developer has all requested information on the organization, structure, and settings of their database file.


 About Microsoft Access Structure Wizard

Microsoft Access Structure Wizard
Copyright 1994, Microsoft Corporation, All Rights Reserved.

Microsoft, MS, MS-DOS, and Microsoft Access are registered trademarks, and Windows and Windows NT are trademarks of Microsoft Corporation in the USA and other countries.  CompuServe is a registered trademark of CompuServe Incorporated, an H&R Block Company.

Microsoft Word was used in the production of this documentation.


Support Policy

The Database Structure Wizard was created by a team of Support Engineers from Microsoft Product Support Services and is provided as an unsupported tool. Microsoft Product Support Services does not provide support for this tool beyond installing it. If you have questions about or problems with the Database Structure Wizard, you are encouraged to post a message in the Microsoft Access forum on CompuServe®. (Type go msaccess to reach the forum.) The Database Structure Wizard team will review all comments and findings posted in the forum.


Installing the Structure Wizard

  Print Instructions

 Follow these steps to install the Structure Wizard

 Insert the WX1050 disk in the appropriate drive.

 Start Microsoft Access and open any database file.

 From the File Menu, choose Add-ins, then from the menu that appears, choose Add-in Manager.

 In the Add in Manager dialog box, choose the Add New button.

 In the Drives box, select the drive containing the WX1050 disk.

 In the File Name box, select WZSTRUC2.MDA (the Database Structure Wizard file) and then choose the OK button.

 Choose the CLOSE button.

 Quit and then restart Microsoft Access.

The Structure Wizard will now be loaded as a library.  The Structure Wizard will be loaded every time you start Microsoft Access, until you uninstall the Structure Wizard.


Uninstalling the Structure Wizard

  Print Instructions

 Follow these steps to uninstall the Structure Wizard

 Start Microsoft Access and open any database file.

 From the File Menu, choose Add-ins, then from the menu that appears, choose Add-in Manager.

 In the Add in Manager dialog box, choose the Add New button.

 In the Available Libraries list, select the Structure Wizard entry

 Choose the Uninstall button.

 Quit and then restart Microsoft Access.

The Structure Wizard will not be loaded as a library.  You will be unable to analyze any database files until you again install the Structure Wizard