make an extra field in the DB for each user called something like "redirectPage" or something, and then for the redirect where it says:
Response.Redirect "blah blah blah", replace with:
Set rsStudent = Server.CreateObject("ADODB.Recordset") 'this should go near the top of your code
and then at the end be sure to put:
set rsStudent = Nothing
hope that helps!