Password protection with group ID

I am trying to setup a password protected site.  I have the login page setup and it works against an Access database.  I have added a groupID much like in the wwForm database.  When someone logs in they are redirected to another.  Different links will appear depending on which group they are in, but I cannot figure out how to check the groupID on the second page against the login id and password.  How can I pass the username and password to the rest of the pages in the password protected area.

Any help will be appreciated.

Thats what I thought, but the groupID is in the database and not entered at login.  How can I use the cookie to get the groupID?

Thanks

IF this works....

name = request.form("name")

sql = "select * from yourdb where name like '" & name & "'"

then do something like.....

if rsportal("GROUPID") = "1" then

response.cookies("ID") = "1"

elseif rsportal("groupid") = "2" then

response.cookies("ID") = "2"

else if rsportal("groupid") = "3" then

response.cookies("ID") = "3"

else

response.cookies("ID") = "0"

END IF

you can do elseif as many times you want or you can use the case 1....

But if you do that then you can have at the top of your pages...

If request.cookies("ID") = "0" then

'display codes for guests or what ever zero happens to be

elseif request.cookies("ID") = "1" Then

'Show the code for this group id OR

'response.redirect "page.asp"

and u need a else then a end if or you get a error....

Please dont critisize the stupid... Not every1 is as smart as -borg- cause the chances are that i waisted my time telling you a code that will never work ...

END IF