Expel Database Users

[Mike]

I have a database on network. Its now getting late and I
need to replicate the database and make some changes to
the tables in the back end. I have one user logged into
the database from a remote location, causing the database
to lock. I need to expel the user from the application,or
close it on their terminal so I can make esign changes. I
have an LBD Viewer, but do not have the capability to boot
a user. Can anyone help me?

 

[SteveS]

At http://www.rogersaccesslibrary.com/ there is a file

LogUsersOff.mdb for A97 (LogUsersOff2k.mdb for A2K)

that illustrates how to automatically log all of your
users out of an application for maintenance purposes.

Also, there is a example that shows how to automatically
log a user out of an application after a period of
inaction. (LogUsersOffNonUse.mdb for A97 and
LogUsersOffNonUse2k.mdb for A2K)

HTH

Steve

 

[berni]

hello steve.
i promise to read the file me too . but one quick
question. once the user is forcely to be logged off, is
he given the chance to save what he had done , added or
modified? is he going to loose any of the data been
working on?
thks. Bernixx

 

[SteveS]

From Rogers download page for 'LogUsersOff2k.mdb':

"When you change the value of Logoff in the Setting table
to Yes, the users will get a message on the screen telling
them that they will be logged off in 5 minutes. The
Switchboard form checks this field every 5 minutes and
launches the message form. If they still have not logged
off after another 5 minutes, they will be automatically
logged off. It will also not allow anyone else to log into
the application until Logoff is set back to No."

It looks like they have (about) ten minutes to log out, so
they should have time to save their data (if they heed the
warning <grin>).

Steve