Kick users out of database 1

[4321z]

Hi,

I've got an access database which is used by multiple users and on occasion i need exclusive use of it and have to do a bit of chasing around to get all other users to log out, does anyone know of an easy way to do this?

 

[BobJacksonNCI]

Take a look at:

http://www.mvps.org/access/modules/mdl0055.htm

Courtesy of The Access Web




HTH,
Bob

 

[4321z]

Thanks Bob what an excellent form that is

 

[MichaelRed]

This topic is also discussed locally (Tek-Tips, various fora), There are a few different approaches which may be of interest.



MichaelRed
mlred@verizon.net

 

[Blorf]

I mention this only in passing, and because I have found it to be very amusing.

I made a table called kick, with one record. A number field, defaulted to 0.

On the main form of the db, I reset the value to zero.

The main forms on timer event, set to repeat every 10 seconds checks to see if the value in Kick totals to anything but zero, and if it does, employes a wonderful vba command. Quit.

I would use it mostly so I could have exclusive access to update vba code, or change a report, but eventuly found it amusing to see other people wonder what happened.

Sorry, could not help it.

ChaZ

Ascii dumb question, get a dumb Ansi