SQL UPDATE syntax error issue

Asked Dec 08 '17 at 09:01

Active Dec 08 '17 at 09:13

Viewed 63 times

I have some SQL where I am getting a syntax error, but cant work out why:

The Code:

CurrentDb.Execute "UPDATE [MS Access;pwd=" & strPassword & ";database=" & DBpath & "\" & DBnameVoice & "].[" & tblhistoric & "] " & _
         "SET NudgeSent = '" & SendNudge & "' " & _
         "WHERE [ID] = '" & UID & "'"

Why I am confused: I have the exact same code but to update a different column and it works fine, what am I missing?

Error Received:

Syntax error in UPDATE Statement

Similar code I have the does work:

CurrentDb.Execute "UPDATE [MS Access;pwd=" & strPassword & ";database=" & DBpath & "\" & DBnameVoice & "].[" & tblhistoric & "] " & _
         "SET AllocatedTo = '" & Allocateto & "' " & _
         "WHERE [ID] = '" & UID & "'"

edited Dec 08 '17 at 09:13

Erik A

31,639
12
42
67

asked Dec 08 '17 at 09:01

dmorgan20

If you get an error, why don't you share the error message? – HoneyBadger Dec 08 '17 at 09:08
Apologies - I have updated my question with the error received – dmorgan20 Dec 08 '17 at 09:12
So the only difference between the two statements is the `SET` clause? What is the value of `SendNudge`? – HoneyBadger Dec 08 '17 at 09:15
Value of SendNudge is the word Yes – dmorgan20 Dec 08 '17 at 09:16
Can you post the actual query being fired? With all variables filled in? – HoneyBadger Dec 08 '17 at 09:18
Is `NudgeSent` a Yes/No field? – Erik A Dec 08 '17 at 09:19
[How to debug dynamic SQL in VBA](http://stackoverflow.com/questions/418960/managing-and-debugging-sql-queries-in-ms-access/1099570#1099570) – Andre Dec 08 '17 at 09:25
NudgeSent is a drop down box with the work Yes in – dmorgan20 Dec 08 '17 at 09:27
@dmorgan20 fields are never drop down boxes. They can have a lookup, but I'm interested in the field type, and not how it looks – Erik A Dec 08 '17 at 09:30
Sorry Erik - Misunderstood, The field is a Text field – dmorgan20 Dec 08 '17 at 09:32
Very odd - Its working now. The SQL has not changed I think I set the name of my table wrong in the external database. Thank you all for the replies – dmorgan20 Dec 08 '17 at 09:43

SQL UPDATE syntax error issue

0 Answers0