Re: database bloat/size

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for the reply, Tony.

"Tony Toews [MVP]" wrote:

After doing a little work in a 40 Mb MDB with not quite as many forms
and reports as yours I frequently would see it increase by about 20
Mb. Then it seems to stay at that mark for a free days or a week
until I compact it again.

How much does it bloat after working with it for few hours and then a
few days.

I typically work on it every day anywhere from 1-4 hours. I compile and
compact/repair EVERY day.

41 Mb is a reasonable size for that many objects.

THAT is the question I was hoping to get some clarity on. Thanks!

Is this a repeating thing or did this just happen once or twice. This
might be caused by accidentally going into the FE MDB twice at the
same time.

It's been a repeating thing. If memory serves the first time it blew up it
had ballooned to about 150+MB within a couple hours. When I
compacted/repaired it went down but had gained some weight! When I went back
to work on a particularly complex query it almost instantly expanded again.
I've found that any time I work on that query I can expect it to balloon. It
never lets me down. Sometimes compacting gets it back but more often it
doesn't.

Never used Access user level security so I regretfully can't share
your pain. Can the security part be done in VBA?

That's a good suggestion. I'll need to explore it.
.

Relevant Pages

  • Re: MICROSOFT OUTLOOK EXPRESS - DELETING TEXT
    ... I compacted my messages this past Friday and I do have "compact message in ... >> extremely slow. ... >> Microsoft Outlook Express, the deletion process works ... >> Mark Muschko ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: OE6 compacts on close always
    ... Mark wrote: ... Assuming you're posting here from the machine in question, the "compact ... count" should be reset to 0 when you compact all folders manually ... To avoid such corruption in future: ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Help with Corrupt db Please
    ... Ive even downloaded a different compact and ... I cant create this form, or rename ... >>Thanks Mark but as I said, thats just one of the things ...
    (microsoft.public.access.gettingstarted)
  • Re: to compact or not to
    ... >Cool it Mark, aside from a missing word, ... >Compact a database while it is running (see ... >Autonumber field to users. ... >sequence and if you should ever want to use Replication, ...
    (microsoft.public.access.formscoding)
  • Re: Mark All Read
    ... and go to Properties | Local File and hit the compact button. ... Also, it happens for a certain newsgroup only, and it is not dependent upon ... using catch-up instead of mark all read takes even more time (it can ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)