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.

Also, count is a reserved word in SQL, use [count] or better: rename the column. — Andre
– Andre, Commented May 25, 2017 at 8:27

Lord Peter · Accepted Answer · 2017-05-25 07:54:07Z

1

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

answered May 25, 2017 at 7:54

Lord Peter

3,5012 gold badges36 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1