hello there, I am hoping one of you access wizards out there might be able to give me a clue to my problem. we have an online CRM application, and what we are finding is that those who log in and log out using the proper log out button never have a problem, but those that close the browser window using the x in the top right eventually have a problem.
IIS times out the connection, but I am wondering if the connection to the database remains open and eventually stops people who do not log out properly from eventually logging on. If we reboot the machine at night, we get one problem free day, but after that it persistes, there is nothing in the event log.
Its Access 2000 database. Is there a way of checking to see how many sessions are open on the DB at any one time, or a way of getting connections to time out?
Any help is much appreciated.
Regards,
D.
I plug you in, dim the lights,
Electric Barbarella !
IIS times out the connection, but I am wondering if the connection to the database remains open and eventually stops people who do not log out properly from eventually logging on. If we reboot the machine at night, we get one problem free day, but after that it persistes, there is nothing in the event log.
Its Access 2000 database. Is there a way of checking to see how many sessions are open on the DB at any one time, or a way of getting connections to time out?
Any help is much appreciated.
Regards,
D.
I plug you in, dim the lights,
Electric Barbarella !