user security question

[galorin]

Is it possible to enable/disable controls based on the Access username or group ID?

I am looking to set up security using Access's built-in user and group permission system. I am using all linked tables, and I want to both disable direct access to these tables, as well as disable routes to forms based on what group a person is in.

i.e. when my file is first opened, I have a Form with three buttons. One for a contacts directory, one for time management, and one for reporting. I want to disable/hide the button that opens up the Time Management section for one group, but leave it enabled for another group. I'd want to do this across the whole project if possible.

How would I go about this?

 

[mp9]

Take a look at this code that lets you determine if the current user is a member of a specified user group or not.

http://www22.brinkster.com/accessory/modules/002.shtml

Call that function to determine user group membership and use the result to set your button's visibility property