Gen-X, I tried your example. The recordset is actually a table of previously used passwords, so the recordset looks like:
But it gives me the error that the function CONVERT is not defined in the expression.Code:rsPasswords.Open "Select * From Passwords Where IdUSUARIO = " & _ rsUsers.Fields("IdUSER").Value & " And CONVERT(varbinary, PASSWORD) = CONVERT(varbinary, '" & _ txtPassword(1).Text & "')", myCN, adOpenKeyset, adLockReadOnly




Reply With Quote