Now the question is......when does it not work?
Of course we always have the single user thing when we need it. More to come.... Dennis McGrath _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernie Corrigan Sent: Tuesday, January 16, 2007 5:06 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Clearing Ghost Connections, and other stuff Hi Dennis - I have seen a number of instances where this method doesn't work. It was supposed to work, but it didn't. Bernie At 12:41 PM 1/16/2007, you wrote: I discovered by accident today that the first connection to a db clears the ghost connections (invalid user count) This works with every version at least from 6.5++ on. One does not have to force single user mode. Just making sure that all connections to the db are closed at the same time once a day should prevent the buildup of ghost connections over time. Dennis McGrath

