> 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
