Re : Error 3186 on Optimistic Locking
Hello,
Quote:
>I have got a problem with optimistic locking. While the user A invoked
>Edit method (not updated yet),
>the user B tried to update (both rs.LockEdits = False) the same record
>that is beging edited by
>user A but the system returned Err 3186.
>As far as I know that optimistic locking locks the page when it updates
>a record.
>User A just invoked Edit method. Why the system locks the page?
Which way do your users access the Data ? Directly in the table or via
Dynaset ?
I believe that accessing data directly by its table (using the seek
method) will lock the data even before the Edit method.
Let me know...
Regards
Patrick Jeantaud
------------------------