Database size has grown dramatically

Posted on 2004-11-10
Last Modified: 2008-02-20
For some reason my database size has grown dramatically.

The MDB used to be 500 KB.

Now it is 22 MB!!!!!

The only thing I've added recently is support for PREVIEWING images.

But the Images I am previewing are less than 100 KB in size, and I re-assign the .Picture property each time.

I am not storing the images inside a table, nor would I even want to do that.

Compact and Repair does nothing to decrease the size the db.

HELP ME RHONDA, HELP HELP ME RHONDA.....or one of you Experts will do as well.  :)
Question by:knowlton
    LVL 8

    Accepted Solution

    hehehe 22 MB is nothing.

    500kb is pretty much an empty db.

    If you are really concerned and want to spend time figuring it out try creating a new db and dropping the object into it one at a time to see which one has the bulk of the size in it.
    LVL 5

    Author Comment

    For the Image Object.........I changed the PictureType property from Embedded to Linked.

    I did this for about 6 different Image Objects I had been using.

    This took my DB size back down to 640 KB  (much more reasonable)


    500 KB seems pretty hefty for an empty db still.......hmmmmmmm.......
    LVL 13

    Expert Comment

    How about create an empty mdb shell and import tables in one at a time checking size differences.  You'll find the table that is the culprit.  
    LVL 5

    Author Comment


    A good idea...but in this case it was the PictureType i was using  (Embedded vs Linked)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now