Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    DB bloat in Access2007 (Access2007)

    When run under Access2007, the attached attached database (created in Access2003) bloats at the rate of about 4k every 5 seconds.

    If you stop it after say 2 minutes, then restart the db, it will start bloating again after about 2 minutes. This suggests to me there is something going on between Access and the operating system (XP), or that somehow Access thinks it needs more space (or that it might need more space?) and asks the O/S for more.

    Bloating also stops if you go into Access Options, then starts again when you get out of it.

    I happened to put the db on a thumbdrive and run it from there. The little light on the drive continually blinked. I tried another db and it didn't bloadt, and the drive hardly blinked. Then another, and it bloated like the first!

    I don't have a clue as to why this would be happening. We are about to bite the bullet and call Microsoft.
    Attached Files Attached Files
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DB bloat in Access2007 (Access2007)

    That's very strange - there should be no reason for continuous disk activity in an empty database. I can't find any mention of this problem. I hope that Microsoft will have a useful suggestion.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: DB bloat in Access2007 (Access2007)

    I posted this problem on the "Utter Access" forum, and I did get a response from the Lead Program Manager for Access. He said he had seen a bug report for this recently, and that it would be fixed in SP2. No more info, so I have no idea what is causing it, or what a workaround might be.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DB bloat in Access2007 (Access2007)

    Well, at least you know that it's being worked on. Thanks for posting the result of your enquiry.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •