Are you actually refreshing the data in the second
application before starting the transaction?

I use this arrangement quite a lot, and it always works, but
your second application needs to open or refresh the data
after the first application has commited a change. Otherwise
it keeps its 'safe' previous view of the data, and making a
further change to the record gives an error.

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