Hi, Don!

I am interested if you had resolved your problem here. I am experiencing quite similar problem-VFP tells me that the uniqueness of my pk field is violated but I could not find any duplicates at all. Mine resulted from a hardware failure. My records got corrupted. In some of my files, I could see strange characters in the records at the bottom of the file. I removed all these strange chars, packed the file, and then tried to recreate my primary index key. VFP would not let me because of uniqueness violation. I issued select distinct, select [pk field], count([pk field])... group by [pk field] and found no duplicate. What I even did was I freed the table and generated a candidate index out of the same field and vfp let me. I reincluded the file into my db container and generated a candidate key from the same field and VFP let me as well. All these that I have done so far proved that there wasn't really a uniqueness violation on that field. Why, therefore could I not generate my primary key?

It looks like the UT community has run out of answers for me, which is scary. Maybe at this point in time you've already resolved your problem and share it with me?

Thanks,
Evelyn