I am trying to update a field in a table. I have been getting this error:<BR>UPDATE tblScenario SET Desc='ftyutfyu67' WHERE ScenarioTitle='dsfgsert' <BR>Microsoft OLE DB Provider for ODBC Drivers error ' 80040e14' <BR>[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in UPDATE statement. <BR>I tried a million different things. But nothing works. The following is the code. Please help.<BR><%<BR>'the primary key that I am requesting from a form<BR>ScenarioTitle = request.form ("ScenarioTitle")<BR><BR>'the field that needs to be updated<BR>description = request.form ("description")<BR><BR>Set MyConn = Server.CreateObject("ADODB.Connection")<BR>Set RS = Server.CreateObject("ADODB.Recordset")<BR>MyConn.O pen "db"<BR><BR>'finding the record that needs to be updated<BR>Set RS = MyConn.Execute _<BR>("SELECT * FROM [tblScenario] WHERE ScenarioTitle = '"& _<BR> Request.Form("ScenarioTitle")&"'")<BR><BR>Dim sql<BR>sql = ("UPDATE tblScenario SET Desc='"&description&_<BR>"' WHERE ScenarioTitle='"&ScenarioTitle&"'")<BR>res ponse.write (sql)<BR><BR>'the following is the statement that gives the error irrespective of whatever form of coding I try<BR>Set RS = MyConn.Execute(sql)<BR>%><BR><BR><BR>Thank you.