Syntax Error trying to upate Access Table

<i><b>Originally posted by : Keith (Malatesta@Mediaone.net)</b></i><br /><br />I am extremely frustrated and my laptop is in grave danger of flying out a second story window... I keep getting:<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 />/update_product.asp, line 24 <br /><br />The code is as follows...<br /><br /><%<br /><br />Option Explicit<br /><br />dim myConnection<br />dim sqlCmd<br />dim rsEvents<br /><br />set myConnection = server.CreateObject("ADODB.connection")<br /><br />myConnection.open "DSN=Shoedb;UID=sa;PWD=;DATABASE=storefront"<br /><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 /><br />& "Category = '" & request.form("Category") & "', " _<br /><br />& "Image_Path = '" & request.form("Image_Path") & "', " _<br /><br />& "MFG = '" & request.form("MFG") & "', " _<br /><br />& "Price = '" & request.form("Price") & "', " _<br /><br />& "where Product_ID = '" & request.form("Product_ID") & "'" <br /><br /><br /><br />Response.Write sqlCmd.CommandText<br /><br />set rsEvents = sqlCmd.execute<br /><br /><br />myConnection.Close<br /><br />set myConnection = Nothing<br /><br />set rsEvents = Nothing<br /><br />set sqlCmd = Nothing<br /><br />%><br /><br /> <br /><br />

<i><b>Originally posted by : Jing Hui (jinghui@poboxes.com)</b></i><br />you've an extra comma that's causing the error.<br /><br />instead of:<br />& "Price = '" & request.form("Price") & "', " _<br /><br />should be:<br />& "Price = '" & request.form("Price") & "' " _<br /><br />