Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Location
    Mpls/St.Paul area
    Posts
    303

    Unanswered: Memory prob: teeny jpg's placed in a table bloat the DB

    Access XP
    Windows XP

    Memory swells when adding a couple of pictures.

    I have a little database with a couple of tables. One field is an OLE.
    I used irfanview (a great free tool) to scale the jpeg files down to less than 10kb each. Then when I add about 10 (1 picture per record, only ten records) pictures the size of the database explodes. Compacting has no effect.

    Before: 480kb
    After: 9,600kb

    When I look at the data table the picture field displays Microsoft Photo Editor 3.0. Is there a configuration option or property to change?


    ty
    John
    This is the day the Lord has made, I will rejoice and be glad in it.

  2. #2
    Join Date
    Dec 2005
    Location
    Texas
    Posts
    13
    Hello Ty,

    The images are causing the bloating. Access does not handle them real well, especially jpeg. Here's a link that will give you some examples to different approaches to reduce/work around the bloating.

    http://accdevel.tripod.com/imaging.htm

    HTH,
    Shane

  3. #3
    Join Date
    Sep 2006
    Posts
    265
    Never use OLE as Objects as Large as Elephants converts jpeg images into bit mapped files hence the bloating. You should externally reference your images and never embed them into the database. Dbpix is excellent for handling images - there is a small cost but it does the trick.

Posting Permissions

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