Hi<BR><BR>I&#039;m getting the following error when trying to update the first record of a table. If I update any other record in the table it works fine.<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80004005&#039;<BR><BR>Query-based update failed because the row to update could not be found.<BR><BR>Here is the piece of code that is causing the error. The Field MatchNo is set up in the table as an AutoNumber. There are 48 records in the table. The error is displayed if nMatchNo = 1 which is the first row. If nMatchNo &#062; 1 then everything updates ok.<BR><BR>Set objPLCollection = Server.CreateObject("ADODB.Connection")<BR><BR>If objPLCollection.State = adStateClosed Then<BR> objPLCollection.Open<BR>end if<BR><BR>Set objMatches = Server.CreateObject("ADODB.Recordset")<BR><BR>strS QL = "SELECT * From Matches WHERE MatchNo = " & nMatchNo<BR><BR>objMatches.Open strSQL, objPLCollection, , adLockOptimistic<BR><BR>if Not objMatches.EOF Then<BR> objMatches("Score1") = 1<BR> objMatches.Update<BR>End If<BR><BR>objMatches.Close