How do I see who is currently in a database on the network, and if possible how do I kick them out?
Posted on 2006-03-31
Hi again. With the database I'm currently developing I occasionally need users to stop using the database so I can make amendments to data and structure to which I usually send out a pop-up requesting everybody gets out of it.
However, like most users they tend to think "I'll do it after I finish this page of records" and at the moment I'm powerless to do anything bar go all over the building and look at the screens (for some reason Remote Desktop isn't working properly for all machines) and give the culprit a roasting while the other users who have complied get irritated through no fault of my own. And guess who takes the flak... IT department.
So at the very least I'd like a means to see who is currently using the database so I can go straight to them and if required I can defend IT by saying "Joe Blogs was the reason, flame him". As a bonus a remote way of booting them off would be splendid.
Btw, if PsFile is suggested I might need someone to explain to me why it isn't working since I think this utility would do the above job but for some reason despite it saying it's closed the file it blatantly hasn't.
I'm offering 500 points since this is pretty detrimental to the speed of the project, and a grade A if you can help with the second part.