Microsoft Office Tutorials and References
In Depth Information
Password-Protecting and Encrypting Your Database
Password-Protecting and Encrypting Your Database
Halt — who goes there? You can tell Access not to allow anyone to open
your database until he or she enters the right password. This system is
allor-nothing, which is a problem. After you allow someone to open the
database, he or she can do anything to the database unless you take additional
security measures. When you add a password to your database, Access
takes the additional precaution of encrypting the database too.
The database may work a little more slowly, however, because Access has
to encrypt and decrypt the information every time it reads or writes the
database file.
Encrypting your database with a password
Follow these steps to encrypt your database with a password:
1. Make a backup copy of the database, and store it somewhere safe.
This backup copy doesn’t have a password. If you lose the password to
the database, at least you have this backup. You may want to burn it on
a CD and store the CD in something heavy that’s locked.
2. Close the database.
3. Make sure that you’re in Backstage View and that no one else has the
database open.
You need sole access to the database to assign a password. In fact, you
need exclusive access, with everyone else being locked out temporarily.
4. Click Computer rather than selecting the database from the Recent list.
5. Browse to the appropriate folder, and select the database you want.
6. From the Open Control drop-down menu in the bottom-right corner of
the Open dialog box, choose Open Exclusive.
Access opens the database with exclusive access.
7. Click the File tab of the Ribbon, choose Info, and click the Encrypt
with Password button.
You see the Set Database Password dialog box, shown in Figure 3-2.
Figure 3-2:
Setting a
password
for a
database.
Search JabSto ::




Custom Search