[AccessD] Force Closing the FE

  FYI, the code Rocky has is from here:

http://support.microsoft.com/?id=210297

  also, there may be interest in passive shutdown which is a middle of the
road approach between doing nothing and forcing users out (it prevents new
users from connecting to the DB but doesn't kick existing users out):

http://msdn.microsoft.com/en-us/library/aa164890(v=office.10).aspx

  You may want to combine that with a idle timeout and/or forced exit.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kovacs, Bruce
Sent: Monday, February 14, 2011 02:22 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Force Closing the FE


I have used this same code in all of my databases since at least 07-Feb-02,
and have had no problems.  I tied it to a table where I can set the idle
time limit depending on the particular installation location.

Likewise, I did not keep track of where I got this.




Bruce Kovacs
URS Corporation

SGT, LLC
7207 IBM Drive
Charlotte, NC  28262

Office:  704-805-2131
Fax:  704-805-2875
Cell:  704-200-8802
bruce.kovacs at urs.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jennifer Gross
Sent: Monday, February 14, 2011 01:35 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Force Closing the FE

Perfect.  Thanks Rocky and Jim - you've given me options to look at.

Jennifer

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Monday, February 14, 2011 10:23 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Force Closing the FE

<<snip>>