"Key column information in insufficient or incorrect. Too many rows were affected by update"

From: JPXA (jpxa_at_rogers.com)
Date: 11/28/03 

Date: Thu, 27 Nov 2003 18:34:33 -0500

Hello!

I have a simple ADO Delphi app that reads one table record and splits it
into two other tables. It works fine until it reaches about 1000 records.
Then I get the following message:

"Key column information in insufficient or incorrect. Too many rows were
affected by update"

The only way to recover (try except does not work), is to shut down the app
and restart. This is no good when I need to parse over 60000 records from
the first table.

Any help is greatly appreciated.

Other Data:
Database: MS SQL 2000
Connection: ADO

Thanks.

JPXA@rogers.com