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.
Post A Reply