It really depends on what you are doing.
If it's not that important that multiple users can edit the same record at the same time, use optomistic. You then need to decide how to handle conflicts. User A changes a record first then User B changes a record. Who wins A or B. You can write code to handle either situation. User B wins, or show User B whats changed and allow them to decide what to do, disallow thier save, etc....
If it is important that more than one user can not edit a record at once, use pessimistic. User A changes a record, User B has to wait until they are finished.
hth
>How would I determine whether I need to use optimistic or pessimistic row buffering?
>
>Thanks
>Nick Patel
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!