Ejecting multiuser

  • Thread starter Thread starter David
  • Start date Start date
D

David

From time to time, users are disconnected or loose connection with our shared
server and it locks up the back end portion of my database. Is there a way
for the administrator to "eject" or disconnect those users remotely?
 
Not the database administrator, but the network admin sure can. I'm not on a
server right now, and I haven't had to do this in a few years, but any
network admin should be able to do this.

You have a bigger problem. Your database isn't split and you have multiple
users using the same file. That's asking for trouble. And you've already got
your share of that trouble. Before you corrupt the database irreparably,
split the database. There's a wizard if you don't know how. Put a copy of
the front-end which contains all the objects on each user's workstation,
linked to the data (back-end) on the server. Here's some guidelines:

http://www.accessmvp.com/TWickerath/articles/multiuser.htm
 
On the server, "Start", "Administrative Tools", "Computer Management", "Open
Files".

If you have admin privileges and you have the computer management snap-in
installed
you can do this from your own computer. Select "Action","Connect to another
computer"

However, I'm not sure how disconnection would cause the BE to lock up.
What version of Server are you running?

(david)
 
Back
Top