Part IV: Professional Database Development
930
Tip
If your database has a password associated with it, the user will still be prompted to enter the password prior
to opening the database.
New Feature
Access contains a new data file extension — .accdr — that automatically opens your Access database in run-
time mode when it’s opened. Change your database file’s extension from .accdb to .accdr to create a locked-
down version of your Access database. Change the extension back to .accdb to restore full functionality.
Encrypting or encoding a database
When security is of utmost importance, one final step that you need to take is to encrypt or encode
the database. Microsoft Access 2010 uses strong encryption, based on the RC4 and large key val-
ues, to secure the data and contents of Access 2010 databases.Follow these steps to encrypt an Access 2010 .accdb database:- Open an existing .accdb database (Chapter26.accdb) exclusively.
- Click the File button in the upper-left corner of the screen, and select the Encrypt with
Password command on the Info tab (see Figure 26.18).
FIGURE 26.18
Choosing to encrypt an Access database