1. There could be several reasons why it is happening, so it's difficult to say exactly why you are seeing this. There is a document on my web site that lists several possible causes.

2. Can you post your PK generation code?


>I have just recently converted a 10 year old FoxDOS program to VFP 6SP3. At this point approximately 400 users have converted over. Two very disconcerting things are happening. 1. Records are disappearing from files. 2. Primary Keys are being violated - that is, duplicate key fields are appearing in tables and the primary key index is being dropped.
>
>As to 1, I understand that the culprit is an incorrect record counter in the file header resulting in records being overwritten when new records are appended. This did happen in DOS from time to time but not with nearly the frequency it is happening now. As to 2, I did not think it was possible to insert a duplicate record into a key field. When this happens any screen using this table refuses to open which effectively shuts the program down.
>
>Two Questions - 1. Is the VFP file system stable? and 2. If it is, then why is this happening to me? By the way, I am running StoneField Database 5.1i and in my newest compile I am running FoxFix 5.0 in the background at startup to check file headers. I do not know if this is going to fix the problem.