N1ck9141

I have delving around on how to disconnect a specific user from a shared database. The only possible senerio I have come up with is as follows:

Use the idle time event to check for the existance of a file in the current project path that is named the same name as the computer that opened the application. If it finds that file it opens up a custom form that says this app is about to shut in 1 min. After 1 minute of the form being open run a Application.Quit accQuitSaveAll operation.

How it will work is that once you have established who is logged in and is not logging out is to send them an empty text file using their computer name as the name of the file. ie Comp21.txt

Then Comp21 will spot the file and quit. You can program the quit routine to delete the file before it quits.

There does not seem to be any solutions on how to remotely disconnect specific users from a shared mdb.

Hope this helps.

Also on the Netsend issue all you need to do is to

Shell(Net Send Comp21 "Message Text",vbHide)
Where Comp21 is the computer you are sending the message to.

Have not tested any of the above.

David

I have posted an updated version of the sample database. This version is a stand alone copy and can reside outside of the target database. Also comes with lock out feature.