Granting access to forms

[Matt W.]

I have a database with multiple forms. It will be security enabled with about
65 users needing a pw. Out of the 65 users, I need only a handful to be able
to see one form and not the other forms, and another handful of users to be
able to see one form and not the other forms. Is this something that I need
to apply in security?
If so, where and how?

Thanks,
Matt

 

[Joan Wild]

You best bet is to set up groups and set the permissions on the groups, not
individual users. You then only need to add users to the appropriate
groups, and they will have the permissions of the groups they belong.

You'd assign Open permission for the form, and also as a minimum Read Data
permissions on the record sources of the forms - these might be tables or
queries.

Study up on security and be sure to practice on a copy of your database. It
can take some time to get it right.
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm