Access Tools  «Prev  Next»

Lesson 2 Setting and modifying a database password
Objective Set and Modify an Access Database Password.

Setting and Modifying Database Password Using Access Tools

At times you will want to limit access to your database or, at least, to some of the information in it. There are three methods for implementing security within Access:
  1. User and Group security can be used to control access to the objects (e.g., tables, queries, forms, reports) in an Access database. The administrator of the database can grant Permissions to individuals, to entire groups, or both, and Permissions can be for use of all or only some objects. This type of security is difficult to set up, requires considerable attention to maintain, and so is generally carried out by an expert.
  2. Roll Your Own security can be implemented without a database administrator. The approach relies on the use of forms to control which parts of the database people can access. This method, however, usually requires some Visual Basic for Applications (VBA) coding to manage, so it is generally done by developers rather than users.
  3. Database passwords can be used to control who can access the database. However, everyone will have the same password and unlimited permissions once inside.

This lesson addresses only database passwords because it is the only kind users generally use. To set the database password, while in the Database window:
  1. Choose Set Database Password from the Security submenu, located on the Tools menu. Once you have chosen this option you will see the following dialog:

Set Database Password submenu

  1. Type the new password in the Password field.
  2. Repeat the same password in the Verify field.

Note that you will only be able to set the database password if you have opened the database exclusively. You can do this by choosing Open Exclusively in the Open Database dialog shown below:
Open Database dialog box

Once you have set the password by clicking OK, you will get the following dialog when you open the database:
Password required dialog box

To clear the database password choose Unset Database Password from the Security submenu, located on the Tools menu, type in the password one more time, then click OK.
In the next lesson we will use the Startup dialog options to customize the layout of your database and the functionality available to users.

MS Access Password - Exercise

Click the Exercise link below to practice setting and modifying a database password.
MS Access Password - Exercise