WX1050: Microsoft Access Database Structure Wizard

• Microsoft Access version 2.0

The "Microsoft Access Database Structure Wizard" (WX1050) Application Note contains the Database Structure Wizard, which is a tool to assist you in documenting and troubleshooting Microsoft Access database applications. The Database Structure Wizard generates tables that detail the organization, structure, and settings of your Microsoft Access database files.

You can obtain this Application Note from the following sources:

• Microsoft's World Wide Web Site on the Internet
• The Internet (Microsoft anonymous ftp server)
• Microsoft Download Service (MSDL)
• Microsoft Technical Support

THE TEXT OF WX1050

           Microsoft(R) AnswerPoint Application Note (Text File)
            WX1050: MICROSOFT ACCESS DATABASE STRUCTURE WIZARD

                                                   Revision Date: 1/95
                                                                1 Disk

 ---------------------------------------------------------------------
| INFORMATION PROVIDED IN THIS DOCUMENT AND ANY SOFTWARE THAT MAY     |
| ACCOMPANY THIS DOCUMENT (collectively referred to as an Application |
| Note) IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER      |
| EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED      |
| WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR       |
| PURPOSE. The user assumes the entire risk as to the accuracy and    |
| the use of this Application Note. This Application Note may be      |
| copied and distributed subject to the following conditions:  1) All |
| text must be copied without modification and all pages must be      |
| included;  2) If software is included, all files on the disk(s)     |
| must be copied without modification (the MS-DOS(R)  utility         |
| diskcopy is appropriate for this purpose);  3) All components of    |
| this Application Note must be distributed together;  and  4) This   |
| Application Note may not be distributed for profit.                 |
|                                                                     |
| Copyright (C) 1995 Microsoft Corporation.  All Rights Reserved.     |
| Microsoft, MS-DOS, and Windows are registered trademarks of         |
| Microsoft Corporation.                                              |
 ---------------------------------------------------------------------

What Is the Microsoft Access Database 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.

What Is the Database Structure Wizard Support Policy?

The Database Structure Wizard was created by a team of Support Engineers from Microsoft Technical Support and is provided as an unsupported tool. Microsoft Technical Support does not provide support for this tool beyond installing it.

How Do I Install the Database Structure Wizard?

Follow these steps to install the Database Structure Wizard:

1. Insert the WX1050 disk in the appropriate disk drive.

2. Start Microsoft Access and open any database.

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

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

5. In the Drives box in the Add New Library dialog box, select the drive containing the WX1050 disk.

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

7. Choose the Close button.

8. Quit and then restart Microsoft Access.

What Files Are Included with the Database Structure Wizard?

The Database Structure Wizard includes the following files:

   Filename       Purpose
   -----------------------------------------------------------------
   WZSTRUC2.MDA   The Database Structure Wizard code library
   WZSTRUC2.HLP   Complete online documentation for the wizard
   WZREADME.HLP   Installation instructions
   ACCERROR.HLP   A complete listing of Microsoft Access error codes
   NLYRPTS.MDB    Sample reports using data generated from the
                  NWIND.MDB sample database

The NLYRPTS.MDB file is a database file that contains sample reports designed to work with an analysis of the NWIND.MDB sample database. Installation of this file is optional. To work with the sample reports, follow these steps:

1. Start Microsoft Access and open the sample database NWIND.MDB.

2. Run the Database Structure Wizard. Make sure to use the default settings and specify that you want the output written to the NLYRPTS.MDB file.

3. Close the NWIND.MDB database.

4. Open the NLYRPTS.MDB database.

5. Preview or print the sample reports.

TO OBTAIN THIS APPLICATION NOTE

You can find WX1050.EXE (size: 409583 bytes) 
                       , a self-extracting file, on the following

• Microsoft's World Wide Web Site on the Internet

        Connect to Support Online at the following address:
  

           http://support.microsoft.com/support/default.asp
  
        Select Access in the "My Question Is About" box.
        Type the following file name in the "My Question Is" box:
  
           WX1050.EXE
  
        Click Find.
  
  

• Internet (anonymous FTP)

        ftp ftp.microsoft.com
        Change to the Softlib/Mslfiles folder.
        Get WX1050.EXE (size: 409583 bytes) 
  

• Microsoft Download Service (MSDL)

        Dial (425) 936-6735 to connect to MSDL
        Download WX1050.EXE (size: 409583 bytes) 
  

• If you are unable to access the source(s) listed above, you can have this Application Note mailed to you by calling Microsoft Technical Support Monday through Friday, 6:00 A.M. to 6:00 P.M. Pacific time at (425) 635-7050. If you are outside the United States, contact the Microsoft subsidiary for your area. To locate your subsidiary, please see the Microsoft World Wide Offices Web Site at:

        http://www.microsoft.com/worldwide/default.htm
  

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online
               Services