Re : Error 3186 on Optimistic Locking 
Author Message
 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
------------------------




Sun, 01 Aug 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Error 3186 on Optimistic Locking

2. Error 3186 - Couldn't save currently locked by user

3. Record locking error 3186

4. File locking error 3186 even when open read only

5. Optimistic Lock: No Error Adding New Record

6. Optimistic Locking and Write Conflict Errors

7. Add a new item also locked with optimistic locking

8. Errors 3265 & 3186

9. Errors 3265 & 3186

10. Error 3186 , Help !!

11. One last Newbie cry for help, re: 3186 error

12. Error 3186, Msaccess VB4 16 Bit

 

 
Powered by phpBB® Forum Software