> What could interrupt the normal flow? And does that mean using two
> databases like this at the same time isn't safe?
> (Of course the problem may reside in my code, but at the moment I
> can't find anything indicating that)

You mention that there has only been a couple of instances
of a problem - in how many 'transactions'?
I get occasional faults, once every few months, and the
operators may just have to retype one record. In your case
that random niggles could happen between the two 'write'
operations. There is nothing to prevent it, but you see the
result, and then have to deal with that. 100% reliability
would be nice but can we actually attain that ?
Your method identifies a problem, which then needs to be
sorted, but it may just have been a power blip that created
the problem?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services