• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 138
  • Last Modified:

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
0
chromenewt
Asked:
chromenewt
  • 4
  • 2
1 Solution
 
Jay_Jay70Commented:
Hi chromenewt,

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!
0
 
Jay_Jay70Commented:
chromenewt,

when you say remote desktop doesnt work... is it enabled on all xp machine??
0
 
chromenewtAuthor Commented:
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.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Jay_Jay70Commented:
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
0
 
chromenewtAuthor Commented:
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?
0
 
Jay_Jay70Commented:
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
0
 
Keith AlabasterCommented:
Just for info,

1. Dameware (www.dameware.com) acts in the same way as PC Anywhere ie you take the machine over as if you were at the box. RDP makes a session to the box.
2. dameware has a self installer; rdp needs to the services to be running in advance (either remote desktop enabled or running TS on 2000)
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now