Recent content by Simon82

Hi @The_Doc_Man, yes, in my case, opening Access in Exclusive Mode avoided the issue, but I preferred a vba-based solution to avoid any action to be taken from client side.

Hi everyone, I experienced same problem and found this post as a great resource of information, so thank you all. Anyway I found a different solution by enclosing the Edit/Update block inside an explicit transaction, as follows: ... DBEngine.BeginTrans rs.Edit...