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.