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
Response.Redirect rsStudent("redirectPage")

and then at the end be sure to put:

set rsStudent = Nothing

hope that helps!