[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