We have made a simple application with a GUI, a business-object and a data-object, as an example how MTS works. When we start 3 applications (continuesly writing data into a database and retrieving a recordset with the complete database), we get deadlock errors in our data-object.
Is there a simple solution to avoid this problem? Maybe using another cursortype or cursorlocation will help? (we tested some possibilities, but nothing helped so far)

Ofcourse handling the error is a solution to this problem, but we would prefer not to cause the deadlock in the first place.

Any ideas or comments are welcome,