Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    214

    Question Unanswered: Database File Size increasing each time it is opened

    I apologize for the vagueness of this thread, but I have no idea what is causing this. I have a 1.3 mb database that has increased file size to 19.0 mb in a matter of two weeks. I have two tables, 1 with 36,000 records and another with 800 in the other. I started the database with the 36,000 records when it was at 1.3 mb, so that doesn't explain why it is increasing. I know I can run a compact and repair every so often, but if anyone knows why this is happening, I would love to know.

    Thank you in advance for your help!
    Mr. Blonde

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    That Access for you

    Just go to Tool ->Database uititltys -> compact and repair

    There a Option to compact and repair on close
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What happens when you run compact and repair?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by mr. blonde
    I apologize for the vagueness of this thread, but I have no idea what is causing this. I have a 1.3 mb database that has increased file size to 19.0 mb in a matter of two weeks. I have two tables, 1 with 36,000 records and another with 800 in the other. I started the database with the 36,000 records when it was at 1.3 mb, so that doesn't explain why it is increasing. I know I can run a compact and repair every so often, but if anyone knows why this is happening, I would love to know.

    Thank you in advance for your help!
    Mr. Blonde
    And are you opening forms and running reports in this db? If so, WHERE do you think Access is going to get the space to operate said forms and reports from? It uses the db for it's internal space requirements ... And the even bigger thing is that is does not even reuse the space used previously. It gets new space every time it runs (that's the secret to your db bloat) ...
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Feb 2004
    Posts
    214

    I think the last answer sums it up

    I was not aware that Access did not write over it's previous space, but created new space (seems like a Microsoft flaw) but no suprise there. I will continue to compact and repair.

    Thanks guys

Posting Permissions

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