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.
Thank you! That was it! I can guarantee you I would never have figured that out on my own. Many, many thanks sir or madam.
maybe try [Password] instead of Password, as it might be a reserved word (i'm too lazy to look it up)