[AccessD] C2DbShutdown

John W. Colby jwcolby at colbyconsulting.com
Wed Feb 18 23:07:41 CST 2004


I have put C2DbShutdown up on my site.

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.

Go to www.colbyconsulting.com and click on the top blue button -
C2DbShutdown.  That will take you to the page with the hotlink that allows
download.  I have been working on it, ironing out a few bugs and writing up
a document so if you saw it or downloaded it previously, please download it
again.

Feedback welcome.

I developed this for my own use and will be integrating it into a client
application in the coming week.  I'll let you know how it goes but it
appears to be functioning quite well at this point.  It is a pretty simple
tool, with a pair of classes and a module with init code.  Nothing too
strenuous there.  The source code is available and is reasonably well
commented.

Check it out and tell me what you think.

Thanks,

John W. Colby
www.ColbyConsulting.com





More information about the AccessD mailing list