Microsoft Office® Access 2007 Inside Out

Encrypting Your Database

Access 2007 includes a new feature to encrypt your database with a password. You can use this feature to prompt users for a password before opening the database. When you encrypt the database, Access makes the data unreadable to tools that can read binary data stored in the physical file.

To encrypt your database with a password, you must first open your database in exclusive mode. Click the Microsoft Office Button, and then click Open. Select your database, and then in the Open dialog box, click the arrow on the Open button, and then click Open Exclusive, as shown in Figure 25-4.

Figure 25-4. You must open your database in ...