help with security level

[nojtuag]

I have a table of user/pass/security1/security2

More, but just need help with this example.

users:
john
james

pass:


9999
8888

Security 1 (Yes/No) - Full Access as Admin.
Security 2 (Yes/No) - User: could modify, but can't delete records.

John will be set a Admin while james is set to User.

On my login form, I have two textbox; one for user and other one for password. One button to Enter.

How will I code so that access know how to filter the user to it's security level if that makes sense?

[Toyman]

I have a table of user/pass/security1/security2

More, but just need help with this example.

users:
john
james

pass:
9999
8888

Security 1 (Yes/No) - Full Access as Admin.
Security 2 (Yes/No) - User: could modify, but can't delete records.

John will be set a Admin while james is set to User.

On my login form, I have two textbox; one for user and other one for password. One button to Enter.

How will I code so that access know how to filter the user to it's security level if that makes sense?

Instead of having two fields to describe the security level, I usually just use one number field, "SecurityLevel". In it, I use numbers from 1-5 depending on the level of security you need; one being the highest level and five bing the lowest.

Once the user clicks on the enter button, you can then use a DLookUp function to look up the security level for the user. If the DLookUp returns a value, then the value is inputted in a hidden non-bound text field in my opening form. If the DLookUp returns no value, then a message pops up asking the user to re-enter the logon info. After three failed trys, the db exits

Once the user successfully logs on, a front page (switchboard) opens with the hidden user level field inputted with the user's security level. Each form that subsequently opens will look for that value to determin which form object will be available for the user

[nojtuag]

you have a simple you can provide cause i'm not too familiar with coding.

Thanks,

[Toyman]

you have a simple you can provide cause i'm not too familiar with coding.

Thanks,

Ok, check out the sample I made. Open the form, frm_Logon. Enter one of the following user's logon. The users are set up with different hierarchy, 1 being the highest and 5 being the lowest. After you log in, the code checks the user's hierarchy number and enables the button the the opened form according to the privlege. After three failed logons, the db closes.

Use these logon info

User: Password: UserHierarchy:
Cookie 12345 1
Pink 12340 2
Blue 12344 3
Red 12343 4
Yellow 12341 5