>Hi! Hilmar
>
>Thank you for your response. How about creating a VFP table with a couple of fileds outside the database. Before modifying, place the order#, user, etc. fields in the table & lock that record. In the save method of the form just delete that record... etc. Do you think this will work.
I am sure that can work. Basically you would create a Locking table. The only information you would need would be the table name, and the primary key expression.
However, I doubt this would be necessary, at least in most cases. With optimistic buffering, the system would NOT overwrite changes done by another user - you would only run the (slight) risk of a user having to discard changes to one record.
Hilmar.
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)
