 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / November 2004Write Conflict Message
During testing of a new multiuser Access 2000 database, one of the users received a write conflict in an area where I wouldn't expect it to occur, i.e., an area where records are appended, not edited. My understanding is that this error occurs when two or more users are editing the same open record. Can anyone think of another reason that might cause this error? Thanks. FYI, I'm using optimistic record-locking. Ken Na rijp beraad schreef Ken : > During testing of a new multiuser Access 2000 database, one of the users > received a write conflict in an area where I wouldn't expect it to occur, [quoted text clipped - 4 lines] > > Ken From memory: Access uses page-locking when excuting add/delete/modify queries (doesn't matter if they are from the interface, from DAO or from ADO). That could explain the error.  SignatureYour eyes are weary from staring at the CRT. You feel sleepy. Notice how restful it is to watch the cursor blink. Close your eyes. The opinions stated above are yours. You cannot imagine why you ever felt otherwise. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.