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:

2. Type the new password in the Password field.
3. 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:

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

MS Access Password - Exercise