---
title: "Set Password in Access Database"  
description: "In this article, I have described how to set passwords in database using the simple encrypt feature. Password protected database is prevent to miss us"  
author: "AVADHESH PATEL"  
published: 2013-04-04  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/1214/set-password-in-access-database  
category: "ms access"  
tags: ["ms access"]  
reading_time: 2 minutes  

---

# Set Password in Access Database

In this article, I have described how to set [passwords](https://www.mindstick.com/blog/301672/how-time-based-one-time-passwords-work) in [database](https://www.mindstick.com/articles/71/how-to-create-xml-file-of-database-in-c-sharp) using the simple encrypt feature. [Password](https://www.mindstick.com/blog/118/retriving-user-password-by-using-stored-procedure-in-asp-dot-net) protected database is prevent to miss used. Steps are given below

Step 1: First open your database with “Exclusive” option as given below image

![Set Password in Access Database](https://www.mindstick.com/mindstickarticle/58c9c143-8fb8-497b-a7e0-633d88bdd1cc/images/419ecfaa-1ae9-4b5c-a591-de1ffdf7b2a5.png)

Step 2: Go to “Info” tag from “File” menu and select “Encrypt with Password” option as below image

![Set Password in Access Database](https://www.mindstick.com/mindstickarticle/58c9c143-8fb8-497b-a7e0-633d88bdd1cc/images/8e548fe4-a625-4154-8cb8-42fe4c6bb171.png)

Step 3: Enter the password and press “OK” button as following image.

![Set Password in Access Database](https://www.mindstick.com/mindstickarticle/58c9c143-8fb8-497b-a7e0-633d88bdd1cc/images/587900c2-5baa-4819-95cc-32a121b4bd30.png)

Step 4: Now test your database it is password protected or not

![Set Password in Access Database](https://www.mindstick.com/mindstickarticle/58c9c143-8fb8-497b-a7e0-633d88bdd1cc/images/e535d2e1-8ea8-4dc0-8dea-c6526b4ec94b.png)

Step 5: Now open your database again. When you open database again it [required](https://yourviews.mindstick.com/view/81031/vigilence-required-during-corona-pandemic) password as below image.

![Set Password in Access Database](https://www.mindstick.com/mindstickarticle/58c9c143-8fb8-497b-a7e0-633d88bdd1cc/images/f2e1ccff-8df9-466b-9797-50251f687a24.png)

When password should be required for opening database hence your database is secured. If you want to remove password means decrypt your database with password then follow below steps.

Step 6: Open database as in step 1.

Step 7: Go to “File” menu and select “Decrypt” option from “Info” tag as below image.

![Set Password in Access Database](https://www.mindstick.com/mindstickarticle/58c9c143-8fb8-497b-a7e0-633d88bdd1cc/images/5702d483-ddcd-4485-9a59-2e25620cea44.png)

Step 8: Enter password which you entered during encrypted time (in step 3) as below image.

![Set Password in Access Database](https://www.mindstick.com/mindstickarticle/58c9c143-8fb8-497b-a7e0-633d88bdd1cc/images/dfb3989b-c06f-4821-bf73-9741a485fed8.png)

I hope this article is helpful for you

---

Original Source: https://www.mindstick.com/articles/1214/set-password-in-access-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.