Role based security

D

Dairy

Hi,

I need to have a role based security on MS-Access forms. The admin user
should have privilage to give access rights for the other users to view
certain forms. Please let me know how do i do this?

Thanks in advance,

Dairy.
 
V

Van T. Dinh

You can use Access Security to do so.

Check Access Help / Access book on Security.

***Note: try it on a _copy_ of the database first, preferably on a test
machine as it is fairly easy to make mistakes with implementing Access
Security.
 
T

Tom Ross

hint:

think of your Roles as Groups. Create groups, Give access to the groups and
assign users to the groups. Users belonging to multiple groups (roles) will
have access that is a composite of the groups they belong to.
 
Top