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