Problem with UPDATE command in MS Access Database from VB.NET

starstarstarstarstarstarstarstarstarstar Rating: 0/5 (0 vote cast) print
Here is the UPDATE command that I am trying to execute:
UPDATE    Issues
SET              Action = 'here we go',
WHERE     (IssueID = 100)
When this update command is executed an error is issued saying, "Syntax ERROR in UPDATE Statement".
If I swap out "Action = 'here we go'," with "ProjNum = '205MV328'," the command works fine.
I think that it is a problem associated with the word "Action", but I haven't found it to be a reserved word in Access.
Any help would be greatly appreciated.
 : kemmerc2     Reply  

Replies (1)

I figured it out. Action is a reserved word and I have to put [] around it in my statement.

: kemmerc2    Reply


Post A Reply

 Questions & Answers