O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Encrypting Your Database

Access 2010 includes a 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 File tab on the Backstage view, 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 27-9.

You must open your database in exclusive mode to encrypt the database with a password.

Figure 27-9. You must open your database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required