How to grant users access to forms

[cracked]

Hi,

This should be really easy one I hope.....

I have a log in screen with username and password text boxes.

I have a form with buttons that lead to other forms.
I have a table called User and another table called Profile.


I want certain buttons on the form enabled to certain users? is this possible?

PS, not sure how secure this method is, but this is only going to be used for a prototype at the moment.

Thanks

 

[pr2-eugin]

Hello cracked, welcome to AWF..

Well what you want to achieve is possible, but you have to set the rules which user has what.. I in my table have a field called as 'privTeam' where I have categories like 'Admin', 'Manager', 'Test', 'Agent', 'Customer Assistant' etc. So I have rules such as Admin has absolute control (that's me ) Manager has privileged view.. somthing like that Agents have absolute no info on reports or callback diary..

To be honest it is a simple play with Switch/If statements..

 

[cracked]

Sorry, your post has not helped.

How can I set permissions to form buttons?

 

[pr2-eugin]

Well that's

I created a small working model of what I meant and have attached the file.. some hint on how to get around.. Make changes to adapt to your code..

 

[MSAccessRookie]

Hi,

This should be really easy one I hope.....

I have a log in screen with username and password text boxes.

I have a form with buttons that lead to other forms.
I have a table called User and another table called Profile.

I want certain buttons on the form enabled to certain users? is this possible?

PS, not sure how secure this method is, but this is only going to be used for a prototype at the moment.

Thanks

I have accomplished this in the past using VBA. In the Login Screen, the User ID that has been entered and verified is stored in a PUBLIC Variable.

There is also a Table of User IDs and Rights.

When each Form is opened, in the ON LOAD Event, the User ID is compared to the Table of Rights, in order to determine the user's level of permission.

Depending on the level of permission, anything from items on the Form to the entire Form might not be available to the user.

I hope this explains how this can be accomplished.

-- Rookie