How ofted should one compact and repair?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Gus <Gus@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 3 Dec 2008 07:34:07 -0800

Hello all,

What is a good timeframe for carrying out the compact and rapair task on a
split database (compacting the back end). I am guessing it depends on how
much a database is being used, but would like to get some input.

What are some indications of a need for compacting and repairing a database?

Thanks for your help.
.

Follow-Ups:
- Re: How ofted should one compact and repair?
  - From: Tony Toews [MVP]
- Re: How ofted should one compact and repair?
  - From: John Spencer

Prev by Date: Re: Required Field Problem
Next by Date: Use a string as a field name
Previous by thread: Re: Return results of INSERT
Next by thread: Re: How ofted should one compact and repair?
Index(es):
- Date
- Thread

Relevant Pages

Re: Access Compact/Repair in ADO.Net?
... Here's the VB6 function that actually does the compacting: ... I keep a file in the same folder as my database, ... opening the database, and if it is, it doesn't let the user run the app. ... Name strSource As strDest ...
(microsoft.public.dotnet.framework.adonet)
RE: Can be access by mutiple users?
... wouldn't shut down quickly enough due to Access doing compacting. ... Compacting is somewhat of a futile pursuit as the database usually just ... a properly split database should not need compacting ... I'm a little confused about the report thing. ...
(microsoft.public.access.gettingstarted)
RE: Can be access by mutiple users?
... "Jerry Whittle" wrote: ... wouldn't shut down quickly enough due to Access doing compacting. ... Compacting is somewhat of a futile pursuit as the database usually just ... I'm a little confused about the report thing. ...
(microsoft.public.access.gettingstarted)
Re: Incredible Expanding Database!
... > One is your position that the database will stay large because it does not ... worth of attachments and HTML messages might be such a time. ... of messages and attachments, then it will significantly reduce the size. ... Compacting (as opposed to doing a full ...
(microsoft.public.mac.office.entourage)
Re: Slightly OT - Trend Scanmail - problem resending quarantined mail...
... You might try compacting the database of quarantined messages, ... Quarantine Management in the ScanMail console (deleting messages older than ... messages that may be preventing a successful resend. ...
(microsoft.public.backoffice.smallbiz2000)