Commiting images in an Image box to database

[Rick B]

Seem to be on a mission today...

How do you store an image inside an Access Database without it taking up so much disk space.

If i store a file which size was say 80k, once saved in the database the file size increases by 3 meg....em!...not good

Help would be appreciated.

[JohnAtWork]

Are you embedding the images, or are you linking to them?

Linking to them would probably minimize the footprint.

[Rick B]

I'm embedding them....I know i could save the file directory and filename and call the required image when the record is displayed.....dont really want to do this.

I think the problem stems from VB takes the file size prior to resizng it into an image box. I think I need to write something that reduces the size of the image prior to commiting it to the actual database.

Waddaya thinx?

[Rick B]

I'm embedding them....I know i could save the file directory and filename and call the required image when the record is displayed.....dont really want to do this.

I think the problem stems from VB taking the file size prior to resizing it into an image box. I think I need to write something that reduces the size of the image prior to commiting it to the actual database.

Waddaya thinx?

[JohnAtWork]

I'm not sure.
I don't have enough experience with Images to really give you the answer you want.

Possibly resizing it prior to embedding it would do it, but I don't know.

You're not using BMPs are you?

[Rick B]

Nah...not using BMP's

I reduced the image size manually to the same size as the imagebox and the amount of disk space reduced from 3 meg down to about 100k which was better. So, I think I'm right in saying that althought the imagebox resizes the image it still retains the original size?????

So if anyone knows how to rezize an image before I load it to the imagebox, it would really be appreciated.

Thanks for your time m8