chromenewt
asked on
How do I see who is currently in a database on the network, and if possible how do I kick them out?
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.
Cheers! :D
Pete
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.
Cheers! :D
Pete
chromenewt,
when you say remote desktop doesnt work... is it enabled on all xp machine??
when you say remote desktop doesnt work... is it enabled on all xp machine??
ASKER
As far as I'm told all the machines have had remote desktop enabled, and as far as I can tell when I look they all appear to have it working except I can't seem to connect except for a handful.
I've had a go with the tools you mentioned but I suddenly thought of a problem; the methods you describe require me to be on the machine the file is on yet the file I'm working on is on the server in a locked room, not my PC I'm working on. I'll have a quick go with remote desktop again but it probably won't work.
I've had a go with the tools you mentioned but I suddenly thought of a problem; the methods you describe require me to be on the machine the file is on yet the file I'm working on is on the server in a locked room, not my PC I'm working on. I'll have a quick go with remote desktop again but it probably won't work.
computer management you can do from any machine as you can connect to another computer - right click
ps logged on will run from the server
ps logged on will run from the server
ASKER
I managed a completely bizarre solution!
I'm using something called Dameware Mini Remote Control which lts me view the users PCs where for some reason Remote Desktop wouldn't. Can you thin kof a reason why this would happen?
I'm using something called Dameware Mini Remote Control which lts me view the users PCs where for some reason Remote Desktop wouldn't. Can you thin kof a reason why this would happen?
ah i have heard about dameware before but never trialled - it doesnt run on the rdp protocol i dont think, so its not restricted in the same way
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
i wont suggest psFile but ill send an option down a similar route :)
http://www.sysinternals.com/Utilities/PsLoggedOn.html
also have you trialled with the inbuilt windows tool - computer management?
right click my computer and select manage - under shared folders you can not only see who is logged on but you can see what files are being opened. computer management also lets you boot people off but in your DB environment i would be careful playing with that!
Cheers!