[AccessD] C2DbShutdown

DWUTKA at marlow.com DWUTKA at marlow.com
Wed Feb 25 16:40:20 CST 2004


LOL.  Figured that.  It's really only a development warning, because you
should never allow your users to get into your source code anyways, so as an
.mde, or a fully developed function, the warning doesn't apply.   

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John W. Colby
Sent: Wednesday, February 25, 2004 3:48 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] C2DbShutdown


The WARNINGWARNINGWARNING mostly.  ;-)

I haven't decided not to use that method but I likewise haven't decided to
use it.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
DWUTKA at marlow.com
Sent: Wednesday, February 25, 2004 4:38 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] C2DbShutdown


By 'Candace's' shutdown method, do you mean monitoring the active
form/control?

Just curious why you didn't go for the keyboard/mouse activity approach.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John W. Colby
Sent: Tuesday, February 24, 2004 11:24 PM
To: AccessD
Subject: [AccessD] C2DbShutdown


Folks,

I just placed a new version of C2DbShutdown on my site.  The new version
incorporates Candaces' method of inactivity timeout for now, so there are
now three shutdown "modes" - Time Windowed, Immediate and Inactivity.  I
have also worked on the document a bit to add explanations of how to use it.

C2DBShutdown is a developer tool designed to provide a quick, easy to use
method of forcing the users out of your database. C2DbShutdown is a library
with two classes and a module, a table and two forms. To use C2DbShutdown
all the developer has to do is:

* Place C2DbShutdown.mda in a common location where all FEs being controlled
can access it.
* Create a reference to C2DbShutdown.mda so that code in that library can be
run.
* Edit the table to create records for each FE being controlled.
* Create a Term function (can be named anything) which includes a line of
code Application.Quit acQuitSaveAll.
* Place the name of this function in SD_RunAtShutdown for every shutdown
record for that application.
* Place a call to SDOpenForm in the application startup code BEFORE any
other code runs.


C2DbShutdown will notify the user with a popup, closeable form that the db
will be closing. After the number of warnings that you specify, code in your
application will be called allowing you to cleanup and close your
application.

Feedback welcomed.

John W. Colby
www.ColbyConsulting.com


--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list