[AccessD] ACC97 - Repair and Compact

http://www.mvps.org/access/modules/mdl0030.htm

...this link is to a sample A97 mdb on Dev's site that allows compact/repair
from within the current db ...it basically opens another Access instance
through automation, closes yours, compacts it, reopens it, and then closes
the 2nd instance  :)

...although the code works reliably, you'd probably be better off rewriting
it to use the Jet Compact/Repair Utility that subsequently came out which is
much, much more reliable imo than the standard A97 compact operation ...HTH
:)


William Hindman
<http://www.freestateproject.org> - Next Year In The Free State!


----- 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
>