DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2
  1. #1
    shachar Guest

    my mdb file size is huge!

    hi all.
    i have a 25 MB mdb file.
    after adding 2 forms and 2 query's to the mdb it is now 31 MB !!
    i already compacted it, but still it's huge!

  2. #2
    Chris Hylton Guest

    Re: my mdb file size is huge!

    First, did you include any 'graphics' on your new forms ?

    That gets imbedded in the MDB file and if it was a large graphic, just adds
    to the size of your file. If you did do this, try removing the graphic and
    load it on the fly instead of having it loaded on the property page of a

    Second, if it's a data issue that compact should have solved...did you use
    a VB compact or the compact from inside MS Access ?

    The compact from VB doesn't always give the same compression/compact level
    as the one from Access. The same is true for the JetComp.exe program that
    can be downloaded from Microsoft, doesn't work as well as the one in Access.
    Don't ask me why, but I've confirmed this NUMEROUS times over the years
    working with Access backends, the only compact that really works well is
    the one 'within' Access.

    Those are two things to check into...outside of those, I'd have to say there
    are extra tables or data there that you aren't aware of...maybe something
    in your new form or query has caused a cartesian product in an insert statement
    or other similar problem in a loop...either of which could cause more data
    than expected to get loaded to a table.


    "shachar" <muli4@zahav.net.il> wrote:
    >hi all.
    >i have a 25 MB mdb file.
    >after adding 2 forms and 2 query's to the mdb it is now 31 MB !!
    >i already compacted it, but still it's huge!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.