Re: Incredible Expanding Database!

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

From: Jim Karpen-PPC mag (jim_karpen_at_pocketpcmag.com)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 16:34:24 -0600

Bill Weylock wrote on 12/21/04 4:00 PM

> You seem to find the results surprising but not all that far off the page.
> Have you ever actually done this routine with better results? I am guessing
> you suggested the process because it should work if I was correct that the
> database seemed to have expanded a whole lot from when I started with
> Entourage. In fact, Iıve only been using it regularly since the first time I
> posted on this group and you asked me ever so nicely to stop using italics
> or you would unleash the hounds of hell. :) Iım guessing itıs been about 4 ­
> 6 months at most.

I use this procedure for archiving and, yes, I've had better results. That
was for Office X, though. When I did it a year ago, the file size was
reduced from 1.1GB to 140MB.

Each year I duplicate the identity, delete much of the past year's e-mail,
compact the database, and start fresh.

Jim

>
> On 12/21/04 8:37 AM, in article BDED9143.81FB4%berkowit@spoof_silcom.com,
> "Paul Berkowitz" <berkowit@spoof_silcom.com> wrote:
>
>> Did you empty the news server cache before compacting? That can reduce the
>> size too.
>
>
>
>
> Panther 10.3.6
> Office 2004
> Windows XP Pro SP2
> Office 2003
>
>

Relevant Pages

  • Re: Automation - running code in one Access DB from another Access DB
    ... Thanks Dave but I can't do what I want to do using dao to open the database ... because the object of my little routine is to empty the tables, compact the ... Sub CompactTables() ...
    (microsoft.public.access.modulesdaovba)
  • Re: Compact and Repair
    ... I don't know about routine but can't you use "Tools" "DataBase ... Utilities" "Compact and Repair" to get the same result, ... set permenantly so when you exit it does it automaticlly. ...
    (microsoft.public.access.formscoding)
  • Compact Database
    ... I am trying to compact a database using the following code at the end of a ... routine to import a table: ... Utilities").Controls("Compact and repair database...").accDoDefaultAction ... It states that you cant compact whilts running code or in a module. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... The autoexec macro opens a ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ... I'm quite certain that you can't Compact an open database from within itself ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... This will cause the database to grow so Compacting ... not split off the tables from your FrontEnd. ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ...
    (microsoft.public.access.modulesdaovba)