How can I password protect a Microsoft Access file?

link|improve this question
Off topic: This belongs on superuser.com, unless it is about programming (in which case you should add what technologies you want to use) – Pekka Dec 28 '10 at 10:02
What do you think you're accomplishing by doing so? You do realize that the database password is more "security theater" than it is actual security, right? – David W. Fenton Dec 29 '10 at 22:48
feedback

migrated from stackoverflow.com Dec 29 '10 at 3:50

This question came from our site for professional and enthusiast programmers.

3 Answers

Menu Extras->Security->Database password. As I use another language, I am not sure if it's called exactly this way.

link|improve this answer
feedback

You could use different approach and encrypt the file and password protect that. Problem is more time / work.

link|improve this answer
feedback

1.Open Microsoft Access 2010 and open the database that you wish to password protect in exclusive mode. You may do this by selecting Open from the file menu and navigating to the database you'd like to encrypt and then click it once. Then, instead of just clicking the Open button, click the downward arrow icon to the right of the button. Choose "Open Exclusive" to open the database in exclusive mode.

2.When the database opens, go to the File tab and click the Info button.

3.Click the Encrypt with Password button.

4.Choose a strong password for your database and enter it in both the Password and Verify boxes in the Set Database Password dialog box, as shown in the image above. Once you've done this, click OK.

5.That's all there is to it. After clicking OK, your database will be encrypted. (This may take a while depending upon the size of your database). The next time you open your database, you'll be prompted to enter the password before accessing it.

Tips:1.Choose a strong password for your database. It should contain both uppercase and lowercase letters, digits and symbols.

2.Be sure to choose a password you can easily remember. You'll need it the next time you wish to open your database!

link|improve this answer
feedback

Your Answer

 
or
required, but never shown