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
chromenewtAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

when you say remote desktop doesnt work... is it enabled on all xp machine??
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.
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

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
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?
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
Keith AlabasterEnterprise ArchitectCommented:
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)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Networking

From novice to tech pro — start learning today.