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
>
>