MS Access Database is one of the most popular Database Management System used to manage and maintain large quantity of data. It is considered as most flexible and the simplest database management system as compared with other Database management system. It is preferred by most of the Microsoft User because of its 'Windows look and feel' and also for its compatibility with other Microsoft products.
Every database stores all type of data including sensitive and confidential data. So it is necessary to manage the proper security of your database to prevent from unauthorized access. MS Access also provides some security features so that data can be accessed by authorized user only. One of such security feature is setting user level permission. User permissions allow database administrator to assign different role to different user according to their requirement. In MS access there are nine types of permission which can be assigned to a user (or a group of user). These nine types of permission and associated roles are listed below.
1. Open - Allows user to open a database, report or form.
2. Open Exclusive - It allows a user to open a database exclusively (other user can not open the database simultaneously).
3. Read Design - It allows user to read/view object design (user can not change the design).
4. Modify Design - It allows user to view, change (or delete) objects.
5. Administer - This type of access have full access to the database and objects. With this permission user can set password to database and assign permission to other user.
6. Data Read - User can view data but cannot edit it (user cannot view design of tables and queries).
8. Insert Data - User can view and insert data but not allowed to delete or change data.
9. Delete Data - User can view or delete data but cannot change or insert data.
It should be noted that before using above mentioned user permissions you should have a clear view about the task of every employee who interacts with the database. For example ‘Data Read’ permission can be allowed to ‘Data Analyst’ user (because he needs to view data only), ‘Insert Data’ can be assigned to user who is responsible for adding new data to the database.
If you are the only user of database then it is not a good idea to use any of the user permission to protect database. In such case you can set password to the main database file (MDB or ACCDB file) so that other user can not access database without your permission. Setting password to the MDB or ACCDB file is considered as the easiest method but you can fall in problem if you forget (which is common human nature) the password of your access database. In case you forget your MDB file password then you can use Access Password Recovery Software to recover password of access database. Such software provides easiest way to recover password of MS Access database file.