using the UPDATE sql statement

[tyedyejenn]

I am trying to change the LockOutUser field for a record in the AgentPay database.&nbsp;&nbsp;I am using the following UPDATE statement but the syntax is incorrect.&nbsp;&nbsp;I am using VB6<br><br>In my code this is all on one line:<br><br>UPDATE [AgentPayDB!]LogIN SET LockOutUser = Y WHERE LogIn.[User ID]=&quot; & &quot;'&quot; & strUserID & &quot;'&quot; & &quot; AND LogIn.[User Password]=&quot; & &quot;'&quot; & strUserPassword & &quot;'&quot;<br><br>Any help is greatly appreciated<br>Thanks in advance<br>Jenn<br><br>

 

[aceng]

I think you forgot to put single quote at lockoutuser value.<br>try this.<br><br>UPDATE [AgentPayDB!]LogIN SET LockOutUser = 'Y' WHERE LogIn.[User ID]=&quot; & &quot;'&quot; & strUserID & &quot;'&quot; & &quot; AND LogIn.[User Password]=&quot; & &quot;'&quot; & strUserPassword & &quot;'&quot;<br><br>