I had problem when trying to retrieve any record which exists in the database(testing.mdb) using the userid. I stored the ID in the testing.mdb as "Text". <BR><BR>If I put rs("ID") = "12345678", it works but when I put <BR>rs("ID") = "&Request("userid")&", it does not works at all.<BR>I&#039m now really lost already. Can anyone help me to find out where my problem lies?<BR><BR> Set objConn = Server.CreateObject("ADODB.Connection")<BR> objConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & <BR> _Server.MapPath(" esting.mdb")<BR>strSQL = "Select * from testing"<BR><BR>Set rs = Server.CreateObject("ADODB.Recordset")<BR>rs.Open strSQL, objConn<BR> <BR> If rs.EOF = False then<BR><BR> Do While Not rs.EOF = true <BR> <BR> If rs.EOF = false then<BR> <BR> If rs("ID") = "&Request("userid")&" then<BR> Response.Write rs("ID")<BR> Exit Do<BR> Else<BR> Response.Write "Error"<BR> End If <BR> <BR> End If <BR> <BR> rs.MoveNext <BR> Loop<BR> <BR> End If <BR><BR>Thanks in advance!<BR>Regards<BR>Jennifer<BR>