Update Problem

<i><b>Originally posted by : Phil (philcrouch@yahoo.com)</b></i><br /><br />Hi all,<br /><br />I have a problem with one of my pages that update my database. I keep getting this error<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. <br /><br /><br />My update statement is as follows<br /><br />MM_genupdate = request.form("S1")<br /><br /> ' create the sql update statement<br /> MM_updateStr = "update gen_info set general = " & MM_genupdate & " where customer_number = " & Request.Form("MM_recordId")<br /><br /> ' finish the sql and execute it<br /> Set MM_updateCmd = Server.CreateObject("ADODB.Command")<br /> MM_updateCmd.ActiveConnection = "dsn=new;"<br /> MM_updateCmd.CommandText = MM_updateStr<br /> MM_updateCmd.Execute<br /><br /><br />ANy idea why i would be getting this error?<br /><br />Thanks for your help in advance

<i><b>Originally posted by : Keith Malatesta (malatesta@mediaone.net)</b></i><br />I am having the same problem....driving me nuts!!<br /><br />set sqlCmd = server.CreateObject("ADODB.Command")<br /> sqlCmd.activeConnection = myConnection<br /> sqlCmd.commandType = 1<br /> sqlCmd.commandText = _<br /> "update product set " _<br /> & "Description = '" & request.form("Description") & "', " _ <br /> & "Category = '" & request.form("Category") & "', " _<br /> & "Image_Path = '" & request.form("Image_Path") & "', " _<br /> & "MFG = '" & request.form("MFG") & "', " _<br /> & "Price = '" & request.form("Price") & "', " _<br /> & "where Product_ID = '" & request.form("Product_ID") & "'" <br /> <br /> <br /> Response.Write sqlCmd.CommandText<br /> set rsEvents = sqlCmd.execute<br /><br /><br /><br />------------<br />Phil at 9/18/2000 7:57:52 PM<br /><br /><br />Hi all,<br /><br />I have a problem with one of my pages that update my database. I keep getting this error<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80040e14' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement. <br /><br /><br />My update statement is as follows<br /><br />MM_genupdate = request.form("S1")<br /><br /> ' create the sql update statement<br /> MM_updateStr = "update gen_info set general = " & MM_genupdate & " where customer_number = " & Request.Form("MM_recordId")<br /><br /> ' finish the sql and execute it<br /> Set MM_updateCmd = Server.CreateObject("ADODB.Command")<br /> MM_updateCmd.ActiveConnection = "dsn=new;"<br /> MM_updateCmd.CommandText = MM_updateStr<br /> MM_updateCmd.Execute<br /><br /><br />ANy idea why i would be getting this error?<br /><br />Thanks for your help in advance