I am trying to update a record in an Access database, and when I send the following statement:
"UPDATE MESSAGES SET TEXT = 'xx' WHERE CODE = 3"
... while debugging I recieve an error, due to the UPDATE instruction syntax...
What am i doing wrong?
I have changed the column name... and I get the exact same error, in the "sintax of the Update statement"...
the sql string I am trying to execute now, is:
UPDATE MESSAGES SET
TEXTMSG = 'Bla, bla, bla',
DATE = #12/12/2005#,
VIA = 2,
DESCRIPTION = 'Bla2, bla2,...'
WHERE CODE = 3