Jef Lee wrote: I believe the IsActive property is not entirely accurate...
>From my tests, you are right about IsActive - it is the results of the last connection (I think) and has nothing to do with the current state. I added a timer function to our VB front end that runs every 60 seconds and just opens a file. If the connection has been lost, the open is unsuccessful. We display a message informing the user that the connection is broken and they need to log on again. This function has almost no overhead and keeps users from spending several minutes or more on a form, then discovering that nothing was saved. It also solved the timeout issue where people would go into a meeting or out to lunch and their connection would be timed out for inactivity. The function runs from only from 6am to 8pm, their local time. If users go home at night without logging out, their connection is still logged out for inactivity instead of being connected all night. Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
