Microsoft Office Tutorials and References
In Depth Information
Protecting your data
Protect a database
6 After the database opens, return to the File menu, and click Encrypt
7 Type a password, type it again to verify it, and click OK.
8 Click OK on the warning message indicating that row-level locking
will be ignored.
TIP To remove a database password, repeat these steps for
the database. At step 6, the icon will be labeled Decrypt
Database. To decrypt the database, you need to have opened the
database for exclusive use.
TIP The warning displayed in step 8 means that although
Access is designed to allow multiple users to share data,
because you have chosen to further constrain the sharing of data with
encryption Access can no longer share data out to other users with the
normal flexibility of locking individual rows, it will lock pages of data.
This is not normally a serious limitation in a database with few users. In
a database which was shared out to a larger number of users you would
probably not want to impose encryption because encryption reduces
performance and in addition, offers less flexibility in the method of