Sorry for posting this again, I think maybe the first posting's title is not catching enough (only 2 reply). I needed help urgently as the system has already when "live" and I've never seen such problem before. This is the scenario:

When 2 users running the same form do data entry together over a network, somehow they will overwrite a record of each other. The value in the field of the primary key is not changed, but all other fields are over written.

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 have 3 records under key-value "1234", but the third record's data belong to those of user_B whose key-value is "1235". Record 1 and 2 for user_A is ok. User_B entry all ok without error.

I'm using:
- VFP 5.0a SP3
- mix of Win95b and Win98
- NT Server 4.0 SP5.

No problem if only 1 user doing data entry. Any idea how is that possible so??? Thanks for any advise.