Kicking users out of Database

[ChampionDuy]

What is the easiest way to kick users out of your database? Some of my users just leave the database open on there desktop when they go to lunch or go do anything other than work, and I would like to be able to kick them out when I need to make changes. Any help would be appreciated.

 

[wh00t]

I can't remember the site I downloaded this from but here's a fe/be database demonstrating logging people off a database with a message.

 

[Graham T]

Rogers Access Library contains an example of Logging User Off:

Rogers Access Library

HTH

Graham

 

[wh00t]

thats where I got it from, thanx I forgot the URL

 

[ChampionDuy]

Thank you very much, I will check it out and let you know how it goes.

 

[Newman]

I tried it and it works great.
Never have to send e-mail to users again.
Thank you!
Newman