UPDATE query VBA issue

  • Thread starter Thread starter DJ
  • Start date Start date
D

DJ

I have an UPDATE SQL statement in VBA which is giving me an error, running
in code, but runs when I copy and paste the SQL into the query window. I am
getting a -2147217900 error, Syntax error in UPDATE statement, from the JET
engine. When I copy the SQL string and place it into a query, I get no
error and the update is made.

Below is the SQL string. All of the field names are correct.

"UPDATE tblGroup SET Active=True, SessionType='Full Day', Status=1,
StatusAsOfDate=#11/14/2005#, StatusComments='', STARLEVEL=3,
STARLEVELAsOfDate=#11/14/2005#, STARLEVELSource='Contracts', NewSpaces=NULL,
Language='', UpdUserID=1, UpdDate=#11/15/2005#, UpdTime=#4:49:50 PM# WHERE
AgencyID='0104' AND CenterID='012' AND ClassroomID='12' AND SessionID='0'
AND GroupID='0'"

Can anyone help me with this? Thank you in advance.
 
Since the SQL works when you run it through the query window, I'd suspect
how you're calling the query in code, rather than the query itself.

What's the VBA you're using to call the query?
 
Back
Top