Hi Robert,

>I tried to understand how the Begin...End Transaction works, I wrote a small looping program, what I found is quite a mystery for me.

Have you used FILEMON on PC #1 to find out what is happening and which record/file is in use? FILEMON is available on http://www.sysinternals.com.