When you implement database security, a password is added to the database that also encrypts the data held therein and makes it unreadable by other tools. Microsoft Access 2007 / 2010 (ACCDB file format) offers new encryption technology that is stronger than that of previous MS Access releases (MDB file format), as it uses a stronger encryption algorithm.
You must have Microsoft Access 2010 or the Microsoft Access 2010 Runtime installed for the database security menu options to be available. Note that you can have Microsoft Access 2003 and the 2010 Runtime installed at the same time. Many, if not most of our databases do house information that could be considered confidential, it is suggested that you protect your database to assure confidentiality of the data.
If you use Access or Public Talks to open the database you will need to supply the password. Remember, it is your responsibility, as the user implementing database security to remember your passwords. It is critical that you remember your password. If you forget your password, Microsoft nor the software developer can retrieve it for you. Store the passwords in a secure place away from the information that they help protect. One possible solution to remember your passwords is to use a password safe. Here is a link to a free tool for this purpose. http://passwordsafe.sourceforge.net/.