Dan Waters
dwaters at usinternet.com
Sat Nov 1 12:38:43 CST 2003
To add on to John' suggestion, you can set up an automatic shutdown at a certain time. In a form which is always open (could be invisible), add a timer event for 60 seconds (60,000 mseconds). The timer event should check to see if you have reached the log-out time. Once you reach the log-out time, display a pop-up form (not modal) to the user that they have X minutes to finish their work. Use the same timer event to count down the X minutes, then Docmd.Quit in code. You'll also need code in your startup form to prevent users from logging in until after the compacting I done. You could also do this weekly in the timer event by checking for the specific day prior to forcing users out. 5 minutes later run the windows scheduler IAW John's instructions. 5 minutes later the code in your startup form should allow users to log in. This gives users a forced 'break' of about 15 minutes. HTH, Dan Waters Quality Process Solutions -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Saturday, November 01, 2003 12:03 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] ACC97 - Repair and Compact In order to do a compact / repair everyone has to be out of the database, meaning (more or less) no FEs are open. After that, just use windows scheduler to do a compact using command line switches. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Tony Septav Sent: Friday, October 31, 2003 6:14 PM To: AccessD at databaseadvisors.com Subject: [AccessD] ACC97 - Repair and Compact Hey All I have a program designed for a client that runs basically 24 hours a day, 7 days a week collecting and processing data. Is it possible to schedule a once weekly repair and compact operation on both the frontend and backend (or even for now just the backend). There is a lag/idle time between 1AM and 4AM, when no data is collected or processed. Any direction to available code, ideas or programs would be appreciated. Thank you. _______________________________________________ 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