Secure database in MS Access with unauthorize persons

Asked By pulmeis 0 points N/A Posted on - 07/11/2012

I have database in MS Access and I just want to know how to put password everytime I open the database so that only selected persons can only access the database.

• Status: Open
• Question Views: 897
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Sharath Reddy

Go To Solution

Answered By Fosso pradha 0 points N/A #161948

Secure database in MS Access with unauthorize persons

Dear User,

First open your existing database and click the database tools tab,

Then select set database password

 

Thank you

 

About Fosso pradha

Questions
1

Answers
247

Best Answers
85

• Vote Up 0 Vote Down

• Posted on - 08/06/2012
• Question Category: MS Access

Answered By Edmund Joseph 5 points N/A #161949

Secure database in MS Access with unauthorize persons

Hi there user:

You may hit the Look-in Box, go to the folder Microsoft Access Database. Hit on the Database Icon.

Open button and then Open Exclusive. On the Tools Menu, unveil the Security. Then hit Set Database password.

Then you can now make your password for your Microsoft Access Database.

Thanks for asking. Send us more post via techyv.com

About Edmund Joseph

Questions
3

Answers
376

Best Answers
166

• Vote Up 0 Vote Down

• Posted on - 11/30/2012
• Question Category: MS Access

Best Answer

Best Answer

Answered By Sharath Reddy 590495 points N/A #161950

Secure database in MS Access with unauthorize persons

This is one great way of protecting your Microsoft

Access database by simply adding a password to it.

Here’s how to set it up.

• Launch Microsoft Office Access but don’t open any database yet.
• Click File, Open then select the database you want to protect with a password.
• Click on the arrow beside the Open button then select Open as Exclusive. Click Open if you received a warning window.
• Click Tools, Security, then Set Database Password.
• Enter your desired password then click OK.

After this, when you close the Microsoft Office Access database and then re-open it again, it will now prompt you for the password. Just supply it with the correct password you set to open the database.

To remove the set password, just go through the same procedure then when you reached the part to click on Tools, Security, click on Unset Database Password instead of the previous option and you’re done.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 12/12/2012
• Question Category: MS Access