Password User level Entry?? Please help me out im really stuck

i want to create a username password form that dependant on user level it grants them acess to different forms
ie
1.manager
types in his username lets say "MANAGER"
and his password "PASSWORD"
and presses the submit form
i want it to search my sql7 database for the acces level number and depending on the level of access it lets him into a certain parts of the members area
can this be done??
i have three levels
1.manager
2.user
3.ME (full access)
so the manager can only see his management type stuff
the user can see his personal details ect ect
and me who ccan search managers and users ect ect

hope you understand what im trying to do thanks for all your help!!!

Hi..sure it can be done...
Try using a fields so-call "status" to classify the user level.

Regards
:o Mac :)

for your reply but i have never done an asp password screen before help me out on this one please or point me in the right direct as i cannot find any books on password screen creations ect ect

Hi..
Maybe this site will help you...


http://www.powerasp.com/content/code...protection.asp


good luck...

:o Mac :)

I have just finished a password page in asp with different user levels!
I wrote an extra field into my SQL database with the level number(i.e. 1,2,3). When the user enters his password, I set that field equel to a session variable :Session("Level")
From there on I just compare everything to this variable, and if it is higher than a certain value, certain HTML elements are displayed, By using simple IF statements!
Hope it helps

my problem is im still learning asp proberly the forthday on it and it all seems pretty good to me
i can make enter forms delete forms update forms but when it comes to password validation im a newbie and have not got a clue where to start??
so could you help me out please???
even just dsome coding to get me started would be greatly appreciated
thanks