Dear All,

Thanks for your ideas and responses.

When I read them all, I decided to explore more of the transaction issues.

After looking through the Database produced nothing I finally went to
the Source code of the Application.

Program was done two years ago and the programmer had apparently left.

From the Delphi code I discovered that the system was in autocommit
mode, but Data inserts data and stored procedures calls were being
done in an explicit transaction and committed or rolled back based on
their success. The other queries and views were not handled in any
special way by the delphi code.

Turns out that if the Application is running and several inserts and
updates are called, there is some rollback by either the database of
application that is 'losing the data' and the users do not know it.

I am now looking at how to fix this, but it is rather weird that it
took an upgrade to windows Vista for it to manifest after 2 years
deployment in about 40 installations....

Thanks for all the Help.


Fidelis M. Muia.