acccess rights

[rcollins]

I am in process of changing around my database frontends. I am curious if there is a way to make items not visible to users if they dont have rights. For example, if I was to have a switchboard for the main menu with items like accounting, behavior, nursing, etc, can I make it to where the accounting people only see the accounting info, but at the same time, someone in behavior may have access to nursing, but not need to see accounting. Is this possible?

[PianoMan64]

Very much so. You have to use a well documented feature in MS Access that is called User Groups.

What you have to do is to create users into groups. Then once that has been created, you use the CurrentUser() function to see who is currently logged In and then you have a table maybe called UserConfig that will has sets of permissions for example:

Table Schema would be like:

ID     UserName     FirstName  LastName     DeptCode
1      UserID1      Fred       Flinstone    Accounting
2      UserID2      Wilma      Flinstone    Nursing
3      UserID3      Barney     Rubble       Behavior
 

You would simply pull the value from the table that would see what department they're in and display information accordingly.

If you would like more detail and code examples, let me know and I can provide you with some.

Hope that helps,

Joe P.

[rcollins]

This sounds like I have to set up all of the users in the access database? I was hoping that I could use authenticationfrom active directory, we have a bit of turnover here and I would have to change a list like this often, when it is already updated in AD. Is this possible?