How to Password Protect a Database in Access 2016
You can password protect a database, to encrypt the data, and provide access control for using the database.
Encrypting a database makes the data unreadable by other tools, and it sets a password that is required to use the database.
Here's how to password protect a database.
The Row Level Locking Message Explained
A block cipher is a method of encrypting text in which a cryptographic key and algorithm are applied to a whole block of data at once, rather than to each bit at a time.
Row level locking (or record level locking) is where a record is locked whenever it is updated. This is to prevent other users from accessing data being while it is being updated.
When you update a record in an encrypted database that uses row level locking, only the record (row) is encrypted, not the whole database.
When you encrypt a database with row level locking disabled, you will receive the Encrypting with block cipher is incompatible with row level locking. Row level locking will be ignored. message.
What this means is that the whole database will be encrypted — not just the record.