Error # = 80040E14
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
NativeError = -3503

I get the above when trying to edit/update and existing record. I get all the fields listed and can enter the data, but when I press the 'Update current record button I always get this error.

My ASP script follows:

<%
Set MyDb = Server.CreateObject(&#34;AspDB.Pro&#34
MyDb.dbUnit = 10
MyDb.DBColor = &#34;black,yellow,gray,white,,,,,yellow&#34;
MyDb.dbImageDir=&#34;../images/&#34;
MyDb.dbGridTableTag = &#34;border=1 cellspacing=3 cellpadding=3 align=center&#34;
MyDb.DbDSN=&#34;DSN=enchantedsw&#34;
MyDb.DbStatusbar=&#34;False&#34;
MyDb.DbMode = &#34;Both&#34;
MyDb.dbSQL = &#34;Select * from carvings&#34;
MyDb.DbMemoTextSize=-1
MyDb.dbNavigation=&#34;both&#34;
MyDb.dbNavigationItem=&#34;Next, Prev, Gridrow, Filter, add, update, edit, delete&#34;
MyDb.dbNavigationIcon=&#34;std&#34;
MyDb.dbEditParams=&#34;Tablename=carvings,Bookmark Flds=ID&#34;
MyDb.dbEditFlds=&#34;1,2,3,4,5,6,7,8,9,10,11,12&#3 4;
MyDb.aspDBPro
%>

Everything else I try to do seems to work fine.