I'm trying to update a table using the following code and keep getting an error 3144 syntax error in the update statement. If I take the where clause out it updates all the passwords in the table.
SQL = "UPDATE SECURITYABS SET " _
& "PASSWORD = '" & UCase(txtNewPW.Text) & "', " _
& "WHERE USERNAME = '" & UCase(txtUserName.Text) & "'"
Any help would be appreciated.