disconnect users from Access 2000 database

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

I have an Access 2000 database on a server and about 20
users each have a vb 6 application on local pc's that
connect to the database. When the database needs to be
compacted some users do not get out of the vb 6
application which results in an error. Does anyone know of
a way to remotely disconnect clients from an Access
database?
 
I am sure that there are many approaches for solving this
problem. I hope that this is one suggestion that might
help.

What you will need to do is write a small routine on a
timer so that your Client Apps will periodically check
for a flag in a one record table of your choosing in the
main database.

Essentially when that flag is TRUE then it is okay to
access the main database. When it reads FALSE then your
VB Client Applications will know that it is time to
automatically exit the application whether a user is
there or not.

An enhancement might be to add a message in another field
to be broadcase to all of the apps.

If you really want to get fancy such a technique could
possibly be used to broadcast messages as well as send
semaphore signals to all of the apps currently plugged
into the database.

Im not on this board too much so you can contact me if
you wish at (e-mail address removed) (erase the NOSPAM).

Ted
 
THe easiest way I can think of is to go to shares on the
server and then press disconect user on the people that
are still logged in. You can do this by right clicking
on "My Computer" then clicking manage.(this is in Windows
2k) then click the top menu and press connect to another
computer. then connect to your server. THen go to
shares, then to open shares, then right click on the user
to be dropped.

James
 
Back
Top