Thanks for replying, sorry that I didn't state clearly in my first posting.
Ok, I'm using optimistic table buffering for all tables and the problem occurred during adding of new records.

Example, user_A added 3 records and the primary key value is "1234", and user_B also added 3 records and primay key value is "1235".

After saving, we realise that although user_A still have 3 records under key-value "1234", but the third record's data belong to those of user_B whose key value is "1235". User_B entry is ok without error.

How is that possible so??? I'm using VFP 5.0a with SP3 running on a mix of Win95b and Win98. Thanks for the help.


>Are you using optimistic or pessimistic buffering? Are they adding or modifying the record?
>
>>When 2 users running the same form do data entry together over a network, somehow they will overwrite a record of each other. The field of the primary key is not changed, but all other fields are over written.
>>
>>All tables are already set to table buffering.
>>Running on NT Server 4.0 SP5.
>>No problem if only 1 user data entry.