Hi Eric,

That was the problem. Thanks.

Al

>Have you retrieved the primary key in rsExpiry ?
>
>
>>Hi,
>>
>>I'm getting an error that is driving me nuts. In the following code, I have two recordsets (Access tables) open - the code simply loops through one recordset (rsExpiry) and for each record attempts to find a matching record in rsMappedDescriptions - if it finds it, the field 'bcImcDescription' is updated in rsExpiry.
>>
>>When it gets to the line of code to update rsExpiry - I get the error message:
>>
>>

>>
>>"Key column information is insufficient or incorrect.  Too many rows were affected by the update".
>>
>>

>>
>>I'm not sure why I'm getting this error message - I've got the exact same code with different recordsets working in other parts of my app - any ideas?
>>
>>

>>
>>Do While Not rsExpiry.EOF
>>
>>        rsMappedDescriptions.MoveFirst
>>        rsMappedDescriptions.Find "CTIProject =" & Trim(rsExpiry!Property_ID) & ""
>>        If Not rsMappedDescriptions.EOF Then
>>            'update the Property name field in rsProperty
>>            With rsExpiry
>>                !bcImcDescription = rsMappedDescriptions!bcImcDescription
>>                .Update   '** HERE IS WHERE THE ERROR OCCORS **
>>            End With
>>        Else
>>            With rsExpiry
>>                 !bcImcDescription = "NOT FOUND IN MAPPING TABLE"
>>                .Update
>>            End With
>>        End If
>>
>>        rsExpiry.MoveNext
>>    Loop
>>
>>