Question How to apply workgroup security level in access 2007

[marcneil]

The purpose of this project is to aim the security mechanism an allow and restrict of individuals or group of individuals of the database. Define the security accounts and groups of users allowed to access.

Users: Can view / add / edit of data into the database.

Superintendent: Has view access to database but is limited only to their section.

Manager: Has full access to database but is limited to their section.

Administrator: Acts as the overall administrator for the database. Has full control over all data and objects contained in the database.

Most likely the closest example of this database is annual leave application. If individuals is/are adding data and only his immediate Superintendent can view with limited to his group and the same with the Manager as we have four (4) sections (Finance; Procurement; Services; & Management) in one unified department.

I would appreciate if someone can help me out to complete this task. If there were some example it would also helpful so I can figure out the mechanism. And other related resources or links; articles in order to understand the application. Thanks

Best Regards,

LittleNathan

 

[apr pillai]

The User-level Security features available in MS-Access ends with earlier versions of Access2007. If you convert your Access2007 Database into Access2003 (.mdb) files you can implement Microsoft Access Security features into it in Access2007 itself.

When you open an .mdb file in Access2007 you can invoke (Running Workgroup Admin in Access2007)the User-level Access Security Features and configure the database for different User-Groups. But, it is a complex procedure you must try out them on a temporary database and find out how it works, before you implement them on the production database.

You start from here: Microsoft Access Security.

Read the Comments Section Posts also.