[ Team LiB ] Previous Section Next Section

Password-Protecting a Database

graphics/08inf04.jpg

graphics/one_icon.jpg

Open the File menu and choose Open to display the Open dialog box.

graphics/two_icon.jpg

Using the Look in drop-down list or the Places bar, open the folder that contains the database you want to open and click the database to select it.

graphics/three_icon.jpg

Click the down arrow next to the Open button and choose Open Exclusive from the list of options that appear.

INTRODUCTION

Chances are, more than one person uses your database. For this reason, you might want to assign a password to that database so that only users with the password can access it. To assign a password, you first must use a special procedure for opening the database, as outlined here.

TIP

Other Security Features

Access provides many more security features, including features for setting up user and group permissions for editing (if several individuals use the database) and encrypting the database contents. For more information, consult Access's online help.

graphics/08inf05.jpg

graphics/four_icon.jpg

The database opens; you can now assign a password. To begin, open the Tools menu, choose Security, and select Set Database Password.

graphics/five_icon.jpg

In the Password field, type the password you want to assign. Then, press Tab, and retype the password in the Verify field.

graphics/six_icon.jpg

Click OK. Access returns you to the database window.

graphics/seven_icon.jpg

If you close and then try to reopen the database, Access prompts you to type the password. Type the password and click OK.

TIP

Not Opened Exclusively?

If you do not open the database exclusively, you'll see an error message when you attempt to apply a password. Clear the error message, close the database, and follow steps 13 to open the database again.

TIP

Dropping the Password

To get rid of the password you've assigned, open the database. Then, open the Tools menu, choose Security, and select Unset Database Password. Type the password in the dialog box that appears and click OK.

    [ Team LiB ] Previous Section Next Section