Re: Bulk Update To Db Tables

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi, I didn't even know about compacting the db. I just did it and now it
reduced to 1.03gb. So do you think I still need to split? I've been using
access for years and always assumed I was using it wrong. I used to use it
to crunch baseball stats and I didn't split tables then either. So if it
works like this, should I keep using it this way? Thanks, Hoop

"John W. Vinson" wrote:

On Wed, 12 Nov 2008 14:16:04 -0800, Hoop <Hoop@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

Hi, this is the first time I've used a forum, so I didn't want to make my
posts too lengthy. I'll try to provide enough info; my old db just maxed out
at 2gig, so I'm stuck for the moment.

Have you Compacted the database? That's absolutely essential if you're doing
lots of deletes and reloading, since Access will not free the space occupied
by emptied tables.
--

John W. Vinson [MVP]

.

Relevant Pages

  • Re: How do I update a table from another MDB ( of same design)
    ... I agree John, but I was concerned that the writer wanted to empty his New ... compacting a table that has ANY records in it will not ... Set up an Append Query (having done this once, ... sales -anything - compact the new sales database, ...
    (microsoft.public.access.gettingstarted)
  • Re: Stopping automatic compacting when closing Outlook Express
    ... I do compact folders manually regularly, but only folder that have "seen ... I didn't need gigs and gigs in hundreds ... It does not automatically start compacting ... "John Foran" wrote in message ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)