Calvin,

I see from later posts here that you are using transactions.
Since I *think* FPD transactions were only available with Novell, and since you discourage your clients from using Novell, I take it that you didn't use transactions in the FPD version.

I would suspect the transactions, especially since you mention peer-to-peer. If any of these customers are running Win95, I seem to remember problems in that OS with record locks. I just have this feeling that transactions are dicey in any peer-to-peer really.

Good luck,

Jim Nelson

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