User Groups and passwords

[Paul]

Hi ALL,
I built an MS 2000 Access database and I want to assign
permissons to two different user groups.
User Group 1 will only be able to access the "Coordinator"
Form.
User Group 2 will have Access to all forms.

When the user opens the DB, based on their group they
should see only the forms assigned.
Thanks
Paul

 

[Joan Wild]

You should download and study the security FAQ. Follow the steps outlined
to secure your database. Once you have the groups set up and their
permissions assigned, you should have some sort of main form that users use
to navigate to forms/reports.

There is code in the security FAQ you can use to determine if a user is a
member of a particular group. In the Open event for your main form, you can
check the current user's membership. If they are a member of Group1, then
hide various command buttons, else show them all.
The security FAQ is available at
http://support.microsoft.com/?kbid=207793

 

[Roy]

If you want to do this without using the Access security
system. Check out Peter's Software site. He has some
neat addins that can help. I downloaded the demo but
haven't installed yet. If it does what is says it does,
it should work for you.