Hi,

My problem is that I can't find a good working mutli-user solution in VB
5.0.

Example :

 2 users are working with the same input form (for example a customers
table with name and address)
User 1 : Change the name of record 1
User 2 : Change the name of record 1
User 1 : Update
User 2 : Update

When the second user is trying to update te record I want to have a
warning that the
name already is been changed by another user. So the second user must
first see the
new data before he can update.

I opened the recordset as a dynaset with OPTIMISTIC locking and the
option dbSeeChanges.
I worked with boundcontrols and a dataobject

I Tried several solutions but I can't find a good solution

Please mail me an example of a GOOD working multi-user solution
     The conditions are : Optimistic locking
                                    Dynaset
                                    Bounded controls
                                    Database Access 97

Source code for the update ??