Password Protect Ms Access db on Opening

Posted on 2012-08-20
Last Modified: 2012-08-22
Hi Experts

How would you password protect a MS Access db so when the user opens up the db
They are prompt to enter a password to proceed to main user form..
Question by:route217
    LVL 14

    Accepted Solution


    Here's How:

    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.
    When the database opens, go to the File tab and click the Info button.
    Click the Encrypt with Password button.
    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.
    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.

    Choose a strong password for your database. It should contain both uppercase and lowercase letters, digits and symbols.
    Be sure to choose a password you can easily remember. You'll need it the next time you wish to open your database!
    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    Here is another approach:

    How to Create a Password Protected Form or Report


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now