• What I did in a situation where the user couldn't update data or if I wanted to update data changed was by "assuming" it was to add a column on each table named RecordVersion.

    When the user reads the data gets version X.

    If someone meanwhile reads and updates the data the version will be X+1.

    When the 1st user sends the data a warning will be shown since the update requires RecordVersion = X and it's not.

    He is warned that the data has been changed since he read it and if he wants to commit it anyway..

    It requires a little more of database programming and the application but it's safer...

    Pedro



    If you need to work better, try working less...