John W. Colby
jwcolby at colbyconsulting.com
Tue Feb 24 23:23:32 CST 2004
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