Boot Current Users Out

[MikeinAZ]

I am trying to figure out a way that I can boot people out of an Access
database so I can perform maintenance and make additions. I know what I want
to do, but I do not know how to write the code or build a macro toset it up:

Ideally, I would like to be able to open up a table or something, change a
field from a "No" to a "Yes" (or "Lock" and "Unlock" and have this action
trigger a message that is sent to everybody that is currently using the
database letting them know that in "X" amount of minutes, they will be booted
out. Then I would need a timer set up to give them "X" minutes to close it
themselves, or then it would close for them.

Thank you very much!

 

[AlanSidman via AccessMonster.com]

Mike;
Look at this

http://www.datawright.com.au/access_resources/access_tips.htm#tip_boot_users

Alan

 

[MikeinAZ via AccessMonster.com]

Alan, I appreciate the help. I could only get this to work for one person,
not if multiple people were in it. Do you have any other suggestions?

Thanks again
Mike

Mike;
Look at this

http://www.datawright.com.au/access_resources/access_tips.htm#tip_boot_users

Alan

I am trying to figure out a way that I can boot people out of an Access
database so I can perform maintenance and make additions. I know what I want

[quoted text clipped - 8 lines]

Thank you very much!

 

[TedMi]

To make this work, you MUST split the database into front & back ends.
Alan's code goes into the front end, so it will run on every user's system
and close down every user. See the bottom of Alan's page for where to put
the extra forms.
-TedMi

Alan, I appreciate the help. I could only get this to work for one person,
not if multiple people were in it. Do you have any other suggestions?

Thanks again
Mike

Mike;
Look at this

http://www.datawright.com.au/access_resources/access_tips.htm#tip_boot_users

Alan

I am trying to figure out a way that I can boot people out of an Access
database so I can perform maintenance and make additions. I know what I
want

[quoted text clipped - 8 lines]

Thank you very much!