Enable/Disable Controls based on Security Group (Access XP)

Topic

New Reply

I would like to be able to enable or disable controls on a form based upon the users security group and I have not been able to find any information on how to do this, or if it is even possible.

As an example, I would like a command button on a form to be disabled if the user is in the security group ROUsers and enabled if they are in the security group PowerUsers.

Any help would be very appreciated, Thanks!

Reply | Quote

Replies

You can get at groups, users and permissions using DAO or ADOX. To be able to uses one of these, you must set the appropriate reference in Tools | References… (“Microsoft DAO 3.6 Object Library” for DAO, and to “Microsoft ADO Ext. 2.7 for DDL and Security” for ADOX.)

For example, the ADOX library contains objects Catalog, Groups and Users. Although the online help can be wayward, it is possible to find examples of using these objects.

Reply | Quote