How to Set Acces database password.

Setting a database password.

1. Close databasename.mdb


2. Click the Open Database button
   - You need to use the Open dialog box.


3. Select databasename.mdb. Click on the arrow next to the Open
   button.
   


4. Choose Open Exclusive to open the databasename.mdb
   database with exclusive access. This gives you the sole access to
   the database when you have it open. You can't set a database password
   if it's in shared access mode. By choosing the Open Exclusive option,
   you prevent other users from opening the database whilst you have
   it open.



5. Choose Tools, Security, Set Database Password
   to open the Set Database dialog box.


6. In the Password and Verify text boxes, type dbpassword.
   Passwords are case-sensitive.
   


7. Click OK to accept the database password and
   close the dialog box.
   


8. Close the database.


9. Let's test the password to see if it works. Open databasename.mdb.
   You must enter the database password to open the database.
   


10. Type dbpassword, and click OK. The database opens.