ACC2: Security Wizard and White Paper for Access 2.0 Available in Download Center (122036)

SUMMARY

The Wx1051.exe file contains two files. The Secure20.doc file is a white paper that contains in-depth information about the Microsoft Access version 2.0 security model to help you understand and use Microsoft Access security effectively. The Secure20.mda file contains the Microsoft Access Security Wizard, which is a tool for easily securing your databases. The white paper includes complete instructions for using the Security Wizard.

The following file is available for download from the Microsoft Download Center:

Download Wx1051.exe now

This white paper contains the following topics:

Overview
Logging On
Permissions
Users and Groups
Creating Your Own Users and Groups: SIDs, PIDs, and Passwords
Ownership
The RunPermissions Query Property
Encryption
Security Enhancements in Version 2.0
The Security Wizard
Common Scenarios
Programming Security
Using Security with Visual Basic Applications

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file. This white paper contains the following topics:

Overview
Logging On
Permissions
Users and Groups
Creating Your Own Users and Groups: SIDs, PIDs, and Passwords
Ownership
The RunPermissions Query Property
Encryption
Security Enhancements in Version 2.0
The Security Wizard
Common Scenarios
Programming Security
Using Security with Visual Basic Applications

MORE INFORMATION

Installing the Security Wizard

After you have downloaded Wx1051.exe, install the Security Wizard. To do so, follow these steps:

Start Microsoft Access and open any database.
From the File menu, choose Add-ins, and then choose Add-in Manager from the submenu.
In the Add-in Manager dialog box, choose the Add New button.
In the File Name box, select SECURE20.MDA, and then choose the OK button.
When the Security Wizard appears in the Available Libraries box, choose the Close button.
Quit and then restart Microsoft Access.

The Security Wizard runs only in Microsoft Access version 2.0. It works with Microsoft Access version 1.x databases provided that they are first converted to Microsoft Access version 2.0 database format. If you try to use the Security Wizard in Microsoft Access version 1.x, you will receive an "Out-of-date database format" error message, followed by the message "Some library modules could not be loaded" when you start Microsoft Access. Databases created by the Security Wizard are in version 2.0 format.

The Security Wizard may take some time to run. For example, securing the sample database Nwind.mdb on a 486/50 computer takes approximately 13 minutes. The Security Wizard's About dialog box gives further information about what the Security Wizard does, as does the doc file included with Wx1051.exe.