jassens
|
| Posted: 01/28/2003, 1:26 AM |
|
I'm getting the following error when trying to Update a record in MS Access:
Source: Record users / Update Operation
Command Text: UPDATE users SET Password='dino1996' WHERE UserId = 'JAS'
Error description: Syntax error in UPDATE statement. (Microsoft JET Database Engine)
UPDATE users SET Password='dino1996' WHERE UserId = 'JAS'
If I copy-paste the UPDATE-statement to MS Access Query it works fine.
What is wrong ???
|
|
|
 |
jassens
|
| Posted: 01/28/2003, 5:09 AM |
|
OK, now I have found the solution myself.
The problem is naming of the table-fields UserId and Password.
Renaming these fields to User_ID and Password_ resolved my problem, at least for now.
|
|
|
|
|
