Encryption and decryption are locking and unlocking in simple terms. Protecting any file with a password is just like locking any gateway with a lock to avoid unauthorized access. So, to prevent unauthorized use of an Access database, consider encrypting the database by setting a password. If you know the password for an encrypted database, you can also decrypt the database and remove its password. However, if you encrypt a database and then lose the password, you will be unable to use the database. You can’t even remove the database password if you do not know the password.

In MS Access you can create user accounts and passwords using a feature called user-level security. If you want to encode or apply a password to an earlier-version Access database (an .mdb file), Access uses the Encoding and Password features but the encryption method of Access 2007(an .accdb file) is different. If you want to safeguard an MDB file, then the most flexible and extensive method of implementing security measure is user level security. With this, you can establish different levels of access to sensitive data and objects in your database. To use a database with user-level security, users type a password when they start Microsoft Access.

Access reads a work group information file, where each user is identified by a unique identification code. The level of access and the objects access level are determined based on this identification code and password. With, User-Level Security Wizard, you can create your own groups of users, and assign or remove permissions for various users or groups of users for a database and its existing tables, queries, forms, reports, and macros. You can also set the default permissions that Microsoft Access assigns for any new tables, queries, forms, reports, and macros that are created in a database. Permissions are granted to groups and users to regulate how they are allowed to work with each table, query, form, report, and macro in a database.

Once encrypted, your database is safe but if you forget the password, then there is no way out. Loosing password is corresponding to losing the data. There are no recovery procedures or decryption methods without knowing the actual password. This can be a catastrophic situation but thanks heaven, you have got recovery tools. MS Access password recovery software can successfully figure out the password from any protected MDB file. They are capable of recovering any password with numeric, alpha-numeric and Unicode character embedded encoding. The tool instantly scans the file and displays the password. Simply select the required file and retrieve as well as copy your password for future references. You can now open your file and even change the password as per your choice.

Kernel for Access password recovery stands on the supreme range of recovery tools. This tool is completely safe and efficient. It can recover multilingual passwords. It recovers the password instantly and even let you save the password for future access. It can open any .mdb file created with MS Access 2003, XP, 2000, 97 and 95 versions.

View all johanhewards's articles

---

About the Author:
The author of this article is a technical writer and has in-depth knowledge about MS Outlook and other email clients. Here, he has focused over PST file size issue which requires us to split pst files. split large pst files to keep Outlook performance up and running.

More Computers & Internet articles