Learn How to Lock Access Database from Editing

  author
Written By Mohit Jha
Anuraag Singh
Approved By Anuraag Singh  
Published On September 27th, 2023
Reading Time 3 Minutes Reading

Nowadays various users are looking for a solution to lock MS Access database (ACCDB) files to protect sensitive data from unauthorized access. Business professionals store crucial and confidential information in the Microsoft Access databases. Hence, the process to encrypt Access database with a password becomes mandatory because it protects databases from viewing, editing, or manipulating it.

This blog post explains the step-by-step process to set password for Access database. Hence, let’s continue reading the article and learn the procedure to lock down Access database files.

Table of ContentsHide

Steps to Lock MS Access Database (ACCDB) Files

  1. Start MS Access 2021, 2019, and 2016, and choose Open.
    Start MS Access
  2. Select the Browse button from Microsoft Access.
    Browse Microsoft Access database
  3. Choose the ACCDB file to set Access database password.
    Select file to set Access database password
  4. Select the Open Exclusive option from the dropdown.
    Choose Open Exclusive
  5. Now you can view Access database, hit the File button.
    Choose File option
  6. After that, choose the Info option as shown in the below figure.
    Select Info option
  7. Select the Encrypt with Password option to encrypt Access database.
    Lock MS Access database
  8. Enter the MS Access database password and verify it.
    Set password for Access database

Recommended: Best Solution for Access Password Recovery

Critical Database Alert: Row-Level Locking Set to Be Ignored!

When you set Access database password, then after completing the last step. MS Access shows a popup message i.e., “Encrypting with a block cipher is incomplete with row-level locking. Row-level locking will be ignored“. If you aren’t aware of this popup message, then below are the main points.

Encrypting with a Block Cipher

  • Encrypting with a Block Cipher: This indicates that data within the database (ACCDB) is being encrypted using a specific cryptographic method that is known as block cipher. Block ciphers encrypt data in fixed-size blocks (e.g., 128 bits) using a secret encryption key.
  • Incomplete with Row-Level Locking: This part of the popup message means that there’s a limitation when trying to implement row-level locking in conjunction with block cipher encryption. Row-level locking is a database feature that allows different transactions or users to lock individual rows of data independently.
  • Row-Level Locking Will Be Ignored: This implies that due to the encryption process row-level locking is not being applied as expected to ensure the reliable and secure management of data within the MS Access database.

Read Similar: Learn How to Unlock Access Database MDB

Check MS Access Database Is Locked or Not

After completing the above-mentioned steps your Access database files will be protected. If you want to check the password protection status of ACCDB files, then follow the below instructions.

  1. Go to the store location of MS Access ACCDB files.
  2. Double-click on the Access database file to open.
  3. See Access database file is asking for a password.
    Lock Microsoft access database
  4. Lastly, enter the MS Access database file password to open it.

Frequently Asked Questions

Que 1: How to lock Access database from editing?

Ans: Quick steps to protect Access database with password:

  1. Firstly, open MS Access ACCDB file Exclusive mode.
  2. After that, choose File >> Info option.
  3. Select the Encrypt with Password option.
  4. Set password for Access database and OK.
  5. MS Access database is locked from editing.

Que 2: Can I encrypt MDB file in MS Access 2021 edition?

Ans: No, MS Access 2021 does not provide built-in database-level encryption for MDB files.

Que 3: Is it possible to access the MS Access database, if forgot the password?

Ans: No, this is mandatory to have a valid password to access the database. However, you can use SysTools software to open Access database without password.