## WX0964: SecurityWizard and White Paper Application Note

Article ID: Q109074
Creation Date: 21-DEC-1993
Revision Date: 30-APR-1997

The information in this article applies to:

- Microsoft Access versions 1.0, 1.1

The "SecurityWizard and White Paper" (WX0964) Application Note contains in-depth information about the Microsoft Access security model to help you understand and use Microsoft Access security effectively.

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 AnswerPoint

For complete information, see the "To Obtain This Application Note" section at the end of this article.

THE TEXT OF WX0964

                Microsoft(R) AnswerPoint Application Note (Text File)
                    WX0964: SECURITYWIZARD AND WHITE PAPER

                                                      Revision Date: 12/93
                                                           1 Disk Included

The following information applies to Microsoft Access(R), version 1.1.

    |---------------------------------------------------------------------|
    | 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) 1993 Microsoft Corporation.  All Rights Reserved.     |
    | Microsoft, Microsoft Access, and MS-DOS are registered trademarks   |
    | and Windows is a trademark of Microsoft Corporation.                |
    |---------------------------------------------------------------------|

The disk included with this document contains two files. The about the Microsoft Access security model to help you understand and use Microsoft Access security effectively. The WZSECURE.MDA file contains the Microsoft Access SecurityWizard, which is a tool for easily securing your databases. The white paper includes instructions for using the SecurityWizard.

To Install the SecurityWizard

1. Copy the WZSECURE.MDA file to your Microsoft Access 1.1 program directory.

2. Add the following line to the [Libraries] section of your MSACCESS.INI file:

          WZSECURE.MDA=RO

- Add the following lines to your MSACCESS.INI file, and then save the file:

          [Menu Add-Ins]
          Security&Wizard==swz_SecureDB()

The next time you start Microsoft Access, the SecurityWizard command will be available on the Help menu.

The SecurityWizard runs only in Microsoft Access version 1.1, but will work with databases in either 1.0 or 1.1 format. Attempting to use the SecurityWizard in Microsoft Access version 1.0 will result in an "Out- of-date database format" error message, followed by a "Some library modules could not be loaded" error message when you start Microsoft Access. Databases created by the SecurityWizard are always in version 1.1 format.

The SecurityWizard may take some time to run. For example, securing the sample database NWIND.MDB on a 486/50 computer takes approximately 13 minutes. The SecurityWizard's About dialog box gives further information on what the SecurityWizard does, as does the text file included on the disk.

The Security White Paper

The security white paper is a text document written by Microsoft Access development. It contains in-depth information on the security model used by Microsoft Access, details on how and why Microsoft Access security acts the way it does, and answers to some common security questions. The file is in text (.TXT) format and is readable by any word processor.

TO OBTAIN THIS APPLICATION NOTE

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

services:

- Microsoft's World Wide Web Site on the Internet

          On the www.microsoft.com home page, click Support.
          Click Search the Knowledge Base, and select Access.

          Enter kbfile WX0964.EXE (size: 211148 bytes)
                                 , and click GO!
          Open the article, and click the button to download the file.

- Internet (anonymous FTP)

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

- Microsoft Download Service (MSDL)

          Dial (425) 936-6735 to connect to MSDL
          Download WX0964.exe (size: 211148 bytes)

- If you are unable to access the source(s) listed above, you can have this Application Note mailed to you by calling Microsoft AnswerPoint 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

For additional information about downloading, please see the following article in the Microsoft Knowledge Base:

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

Additional query words: appnote softlib
Keywords : kbappnote kbfile ScrtOthr
Version : 1.0 1.1
Platform : WINDOWS
Hardware : X86

> THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

©1997 Microsoft Corporation. All rights reserved. Legal Notices.