"Records Lost" error, but they aren't

[DataMiner]

I am getting one of those key violation errors, "the contents of fields in 0 records were deleted, and 3 records were lost due to key violations".

However, I can't find any key violations, and if I just say "proceed anyway", no records are lost.

THis is happening during a transfertext operation, importing a text file into an existing table. All the fields and all the records seem to import just fine. It's just that my code gets stuck on this dang error message.

I don't think I can trap this error (see MS KB #197596).

I've already tried repair/compact the database, no change.

Any ideas on why this might be happening???

 

[sfreeman@co.mer]

ImportErrors

You should get any errors or lost data in a system generated table called "tblName_ImportErrors", which will show you exactly what was lost.

Was such a table created??

 

[DataMiner]

No, no import error table was generated.