UPDATE statement syntax error

[Shweta]

Hi All,

I am trying to run the below code in access 2013 vba editor however it is showing as undate statement syntax error. kindly help.

Sub abc()
Dim sSQL As String
Dim DB As Database


Set DB = CurrentDb


sSQL = "UPDATE TABLE Employee SET [Notes] = 'Under Paid' WHERE [ANNUAL CTC] < 400000;"


'DB.Execute sSQL
DoCmd.RunSQL sSQL
End Sub

Thanks in advance!

 

[Joe4]

Try removing the word "TABLE" from your SQL statement (since you can only update tables, it is implied that the object following the word UPDATE is a table):

sSQL = "UPDATE Employee SET [Notes] = 'Under Paid' WHERE [ANNUAL CTC] < 400000;"

 

[Shweta]

Thank you so much Joe4!

Later on I realised this mistake.