Hello, I am so close to creating finishing this one time password. It is like this.<BR><BR>Table Name: passwords<BR><BR>Two fields:<BR><BR>Password: "text" display<BR><BR>HasTaken: "Yes/No"<BR><BR>The idea is for the Password fields to have a list of passwords, , so when a test taker puts in a password for the first time, they enter the test...(test.asp)<BR><BR>If that password is used again, they are told it&#039s been used and go nowhere, as if it&#039s invalid. Question, where did my code go wrong? It tells you when a password is invlalid, BUT, instead of taking first time password users to the test, it prevents them and says it&#039s been used. Here&#039s the code...(connection part cut off for time saving...)<BR><BR>rst.open "Select * From passwords", Myconn<BR>rst.MoveFirst<BR>&#039 Search for the password<BR>Do While NOT rst.EOF<BR>If rst("Password") = pwd Then<BR><BR>&#039 See if that password has been used before<BR>If rst("HasTaken") = True Then<BR><BR>&#039 Store for use on other pages<BR>&#039 You can use a cookie if you prefer.<BR>Session("ID") = pwd<BR><BR>&#039 Set the database field to show they have taken the test.<BR>rst("HasTaken") = False<BR>rst.Update<BR><BR>&#039 Send them to the quiz<BR>Response.Redirect "test.asp"<BR>Else<BR>&#039 The password has been used before.<BR>result = "TAKEN"<BR>End If<BR>End If<BR>rst.MoveNext<BR>Loop<BR>rst.close<BR>Myconn. close<BR>Set rst = Nothing<BR>Set Myconn = Nothing<BR>End If<BR>%&#062;<BR><BR>Thanks for your help.<BR><BR>Joel Holtzman<BR><BR>