Results 1 to 7 of 7

Thread: bloating (2000)

  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    Eastern Pennsylvania, Pennsylvania, USA
    Posts
    97
    Thanks
    0
    Thanked 0 Times in 0 Posts

    bloating (2000)

    Hey All,
    I have a relatively simple dbase in Access 2000 that manages projects and contacts. The size is a ridiculous 50 mb. Compacting does almost nothing. There are 2 modules opening recordsets, but I ALWAYS explicitly close them immediately after their usefulness is ended. Other than that, there is nothing too funky going on. I have never seen this before.I have full blown apps doing very advanced tasks that are not even 1/10th the size. Does anyone know the cause, and how to solve this and reduce the size?
    Thank you in advance,
    Dave P.

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

    Re: bloating (2000)

    Do you have OLE fields in your database, such as images? Images are notorious for blowing up the size of an Access database.

    It may help to import all database objects into a new blank database. You will have to set the startup options for the new database, and if you have non-standard references in VBA, you will have to set them in the new database too.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: bloating (2000)

    Along the same lines as Hans, images on forms are notorious for bloating a db size. Using a 'default' theme on a form is fine, but if you put background images of your own, it gets stored with Bitmap sizes.

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

    Re: bloating (2000)

    Another thing you can try is to decompile the database. Start access with /decompile in the command line, then select your database. Compact afterwards.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    Star Lounger
    Join Date
    Mar 2001
    Location
    Eastern Pennsylvania, Pennsylvania, USA
    Posts
    97
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: bloating (2000)

    Thank you all for the suggestions. I have been able to reduce it to 34 mb, still big, but not as bad. Thank you

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: bloating (2000)

    Do you have Name Autocorrect turned on, by any chance? Check Tools-->Options-->General from the database window if you aren't sure. That can be a significant part of bloating, so turn it off if you haven't already.
    Charlotte

  7. #7
    Star Lounger
    Join Date
    Mar 2001
    Location
    Eastern Pennsylvania, Pennsylvania, USA
    Posts
    97
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: bloating (2000)

    Charlotte,
    yes it is on. I'll disable it and see if it helps. Thank you , Dave P.

Posting Permissions

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