Error in UPDATE statement Syntax with VB.NET and MS ACCESS

Question

Friends,

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?

Answer 1

The column name TEXT is a reserved word. You can either enclose it within brackets (e.g. [TEXT]) or rename the column.

Answer 2

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

 

Thanxs again.

 

D.

Answer 3

DATE is a reserved word. You may want to check the below lists before naming your columns:

List of Microsoft Jet 4.0 reserved words
List of reserved words in Access 2002 and Access 2003

Answer 4

Excelente Paul. Thank you very much.

Answer 5

This is what happens when you go from SQL to Access.  All heavens breaks loose!  I have been trying to solve this problem for 2 darn days!!

 

ahh.... "Only Access"

Answer 6

Thanks so much for the link to the reserved words!

I've had a few errors of this type, yet I have no idea usually which word is causing it.

A bit of Cmd + F is all I need to find them now!

- Formby.

Answer 7

Thanks Paul, your answer is very helpful for me. Hopefully you can help me to solve other problem if i've new one that i don't understand.