Denise,

First neither pessimistic nor optimistics has someone overwrite anothers data. With pess. the possible collision is sensed at the start of the edit and the edit is refused if the record is in use, with opt. the collision is sensed at the time of writing and the second user is informed that the data has changed and that their work cannot be saved.

All of that works fine with local data, as VFP can lock the records in the actual tables. As soon as views are used pess. goes out the window. The view is always buffered optimisitcally as it is local to the workstation and there is no direct link back to the actual table. All data conflicts must be sensed during the write back operation. C/S is all done with views so there is no pessmistic buffering possible.