[AccessD] Gaining Exclusive Access

Thomas,

I did something similar a few years back...with a timer on the forms 
used...the form periodically (I used 5 minutes)checked the value in a 
table...if the value had changed (something I changed) it would open a 
form(didn't use msgBox because I couldn't count time on those) that warned 
the user they were about to be kicked out in a certain amount of time...if 
they DIDN"T respond to the message in a certain time...they were booted...if 
they DID respond but didn't close...they were booted at the time.

Sorry I don't have an example to send.  Also, I had to check that value when 
the db opened...so they couldn't close and reopen.

Hope that helps,

Mark A. Matte


>From: ewaldt at gdls.com
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Gaining Exclusive Access
>Date: Wed, 7 Jun 2006 14:22:38 -0400
>
>I understand that Access offers much in security. However, I really only
>want one special item: If I need to get exclusive access to the database
>(for programming purposes, for example), I want to be able to boot any
>current users out of the database. What is the easiest way to build this
>into the system? The problem is that some users have the habit of locking
>their computers when they go to meetings, which is a good thing, but they
>have accessed the database before leaving, which is not a good thing. It is
>currently a simple one-file .mdb.
>
>TIA.
>
>
>Thomas F. Ewald
>FCS Database Manager
>General Dynamics Land Systems
>(586) 276-1256
>
>
>
>
>
>This is an e-mail from General Dynamics Land Systems. It is for the 
>intended recipient only and may contain confidential and privileged 
>information.  No one else may read, print, store, copy, forward or act in 
>reliance on it or its attachments.  If you are not the intended recipient, 
>please return this message to the sender and delete the message and any 
>attachments from your computer. Your cooperation is appreciated.
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com