>Thanks for your reply.
>
>You are right in that the problem occurs because several users are trying to save records at the same time.
>
>I will try to change the buffering and let you know.
Mike Yearwood says it isn't convenient to use optimistic buffering, if there is a risk that the same record will be used. My opinion on this is the following: Normally, data won't be overwritten in this case (depending on the parameters for TableUpdate() - see help); VFP will detect the conflict, and the record won't be saved. However, if this happens often, it can be inconvenient for the users.
You can also use explicit record locking in some individual cases. Again, you have the problem of record being locked for too long a time (while the user is editing).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
