Dave Sharpe
davesharpe2 at cox.net
Sat Nov 1 12:30:26 CST 2003
Tony I use the "lite" ( free version ) of this that can't schedule; but , I beleive that the "full" version has scheduling Access Maintainer developed by Gracemere Software http://www.gracemere.com Dave ----- Original Message ----- From: "John Colby" <jcolby at colbyconsulting.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Saturday, November 01, 2003 1:03 PM 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