Aug 25 2011, 01:45 AM
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?
Aug 25 2011, 06:36 PM
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!
Sep 13 2011, 02:17 AM
So sorry for the late reply.
I have DL your access but still done really understand.
Can you explain again?
So sorry about it.
Sep 13 2011, 02:19 AM
I enter my username in the table but when i open the frmMenu, nth in the list below.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here