[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 569
  • Last Modified:

Password Protect Ms Access db on Opening

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..
0
route217
Asked:
route217
1 Solution
 
John-Charles-HerzbergCommented:
from:http://databases.about.com/od/tutorials/ht/Password-Protecting-An-Access-2010-Database.htm

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.
Tips:

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!
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Here is another approach:

How to Create a Password Protected Form or Report
http://support.microsoft.com/?kbid=209871

mx
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now