Kicking user out of database

[Mike]

Now that I know how to see who is connected to the
database, is there a way that I can terminate (or kick
out) a user from the database? Please let me know if this
is possible or not. Thank you for your time.

Mike

 

[Kristyn Wagoner [MSFT]]

There is no built in way to force users to quit Microsoft Access. And it is
not a good idea to just disconnect the user from Network solutions. That can
cause the database to become corrupted.

This article shows you one approach that you can use to gracefully shut down
a front-end Access database application. You can also use many of these
concepts to compact or repair the database, make backup copies, and so on.

304408 How to Shut Down a Custom Access Application Remotely
http://support.microsoft.com/?id=304408

--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Roger Carlson]

On my website(see sig below) is a small sample database called
"LogUsersOff.mdb" which illustrates one way to do this.