I grabbed a module a while back from Microsoft's site, i cant remember the name, but what it does is tell me who has the database open (via computer name).
The problem I am having is that when the database closes (DoCmd.Quit acQuitSaveNone) the ldb file still shows people logged in. I double checked to make sure that the database is closed on all the computers that are using it.
The ldb file will eventually clear itself out after a couple of hours but if I am trying to throw a change into one of the forms I can't wait around for the ldb file to disappear so I can have "exclusive access" to the db.
Is there a Quit that will kick the user out of the ldb file faster?
The problem I am having is that when the database closes (DoCmd.Quit acQuitSaveNone) the ldb file still shows people logged in. I double checked to make sure that the database is closed on all the computers that are using it.
The ldb file will eventually clear itself out after a couple of hours but if I am trying to throw a change into one of the forms I can't wait around for the ldb file to disappear so I can have "exclusive access" to the db.
Is there a Quit that will kick the user out of the ldb file faster?