Syntax Error - Update query MS access

Question

I am getting syntax error for below code: Please help

 db.Execute "UPDATE Account_Manager_Details" _
    & "SET count = count + 1 " _
    & "WHERE ID = " & id & ";"

Thanks You.

[How to debug dynamic SQL in VBA](http://stackoverflow.com/a/1099570/3820271) — Andre, May 25 '17 at 08:27
Also, `count` is a reserved word in SQL, use `[count]` or better: rename the column. — Andre, May 25 '17 at 08:27

score 1 · Answer 1 · answered May 25 '17 at 07:54

You need a space between the table name and the "SET" statement.

db.Execute "UPDATE Account_Manager_Details "

It's a good idea to assign your SQL statement to a string before you execute it, then you can see exactly what you are doing.

sSQL = "update account_manager_details ... " _
db.execute sSQL, dbfailonerror

1 Answers1