HI All,

I have create a table to store USerId, Password, and securityLevel.
I a have few forms and each user have different access right to the forms.

Can anyone teach me how to create the access right Level?
Is there any sample i can see?

Thanks.

The normal way I do this is through a menu with access assigned to the level of user. Check the sample I have attached!


If you want to make it work:
1. Enter your login name as a new entry into the "User" table
2. Assign which level of permission you want in the AccessLevelID field. You can look up the ID you want to assign to yourself in the AccessLevel field.
3. Open the frmMenu form.
4. Change the "AccessLevelID" value for your username in the User table.
5. Close and reopen the frmMenu form. The number of items in the Menu should change based on your AccessLevelID

In this way, only the accessible items are available from the menu. In order to make this more secure, you would need to hide the MS Access database window and stop it from being unhidden using F11.

I would also enhance this to give an administrator a form where they could edit the user values. This is just a start point to show you how it can be done!

This post has been edited by blobbles78: Aug 25 2011, 06:42 PM

HI,

So sorry for the late reply.
I have DL your access but still done really understand.
Can you explain again?

So sorry about it.

Thanks.

FYI,

I enter my username in the table but when i open the frmMenu, nth in the list below.