How to apply the workgroup security level in access 2007

marcneil

New member
Local time
Today, 19:18
Joined
Sep 30, 2013
Messages
5
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
 
Dear Teacher,

I have found example in the net filtering the current user. Now this about 75% met my requirements, however, i wanted to filter the main data while the leader of the group accessing the database and he can only view his section and rest of others section.

My problem is the method to apply into the form! whether through by vba to call the method or in the Open Event of the form.

Appreciated your assistance.

Best Regards,
 
Dear Teacher,

kindly please tell me if i'am posting the wrong category, so i can post it back into the appropriate discussion, i'am a newbie here in this forum. thanks
 

Users who are viewing this thread

Back
Top Bottom