I&#039m facing a problem when updating my Access database.<BR><BR>This is a weird problem as because it occurs infrequently, does not occur in some databases & recurrs in some. The database I&#039m using is Access.<BR><BR>This is the error :<BR>*******<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)<BR>[Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect<BR>*******<BR><BR>& this is the code :<BR>(the &#039q_text&#039 field is a Memo field)<BR><BR>************************************ <BR>myTimesCorrectSQL="Update Question set TimesCorrect=TimesCorrect + 1 where q_text = &#039" & Session("myArray")(1,x) & "&#039"<BR><BR>Set myTCRs = Server.CreateObject("ADODB.Recordset")<BR>myTCRS.C ursorType = adOpenDynamic<BR>myTCRS.LockType = adLockOptimistic<BR>myTCRS.Open myTimesCorrectSQL,myResultConn [[the error line]]<BR>*******************************************<BR ><BR>Could anybody help me out of this error. It&#039s causing sleepless nights to me.<BR><BR>