> Thanks Svein, I will re-check all the transactions but am careful to start and
> commit transactions. This isn't a general problem with the program, it seems
> to be isolated to this user. Something you said did strike a chord though. This
> user does tend to have users that use terminal server to access the system.
> If they are not logging out of TS could this be a potential cause?

Depends on several things.

If a user walks away from their PC with your application running, how likely is it that your application would have an open db transaction?

Closing a TS sessions (ie. not logging out) is like walking away from the PC.


Is the TS setup to logoff/kill idle sessions?

If not, applications will continue to run without end. The next time to user connects to TS, they will pick up the previous session.


Sean