We have a legacy financial application that was ported a few years back from Access to SQL Server 2000. Users still access the server through a MS Access form front end. We have an ongoing problem in which the user access form continually gets corrupted and users have to redownload this form from the server. I suspect but don't have any real proof that form is getting corrupted because the majority of our users who access the system (directly from their desktop or via terminal server) never logout and usually leave the application up and running for many hours at a time.
I am looking for a way to automatically log the users out and terminate the connection to the database if the connection has been idle for a certain period.
If there are any other suggestions as to why this issue maybe occurring it would be greatly appreciated.
Thanks in advance.