Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Northern, NJ, New Jersey, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Db size with Images... (2000 SR1)

    I have a database 3.5MB in size. I linked to 14MB of photos to be displayed in forms. The database is now over 170MB. New math? I have tried linking and embedding the images, but both cause the bloating. No one wants an icon to click on to view photos as they are displayed in the Db and on output forms.

    thuughts???
    There is always a way.

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

    Re: Db size with Images... (2000 SR1)

    What do you mean by "linked to 14Mb of photos"? Did you directly link them to forms? Graphics in a database should always be used sparingly because they cause huge bloating, especially if the graphic is in any format besides bitmap, since Access also creates a bmp image to match. The preferred method is to load the file path into the picture property of an image control when you need the image. You can find a sample of that technique in the attachment to <post#=404883>post 404883</post#>.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Northern, NJ, New Jersey, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Db size with Images... (2000 SR1)

    We are trying to display without effort photographs of stores on a form which we also print on reports. Currently the photos are linked or embedded, ie, ole object. We do not want the user to click an icon to view a photo.

    In response to your earlier solution.. would it be better if the photos were bmp to start with rather than jpg?
    There is always a way.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Db size with Images... (2000 SR1)

    If all your photos are linked and you are using an OLE object to insert each picture, you are doing right. Not sure of the file bloat. Could it be coming from something else? Did you try to Compact and Repair your database? Tools...Database Utilities...Compact and Repair, and then check the file size. Just a thought. I saw a database today that was many megabytes large...after compacting it wasn't even 500 KB. Worth a shot? (Some may say different, but I choose to make a backup before I compact and repair...on the suggestion of Microsoft itself)

    NMP
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

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

    Re: Db size with Images... (2000 SR1)

    Did you look at the sample database? It uses different formats and it doesn't require clicking an icon. It would be better if you didn't try to embed the things because they seriously impact the performance of the database.
    Charlotte

Posting Permissions

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