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