I am getting a syntax error when I try to run this SQL statement:
UPDATE users SET Password = 'newpass' WHERE Username = 'Graham';
I commented out the line that executes this in order to create this thread so I know that this is exactly what would have run. The data type for both fields is text. When I take this statement and use it to create a query in Access it works just fine. I am clearly missing something very basic. I have gone over each field letter by letter to confirm that this problem is not due to a typo. Any ideas? Thanks in advance to anyone willing to help.