Images In Access

[DS]

I'm trying to figure out image size in Access.
I'm using the unbound image field.
I was first using Bmps. they were about 14 KB each, so i went to
optimized Gifs which made the image size 1.5 KB I thought great thats
musch smaller! ...but the database remained the same size after I
changed the images to Gifs. I compacted the database and opened a new
container then moved all of the forms over, perhas I did something
wrong, am I missing something? Am I misinformed? Any info appreciated.
Thanks
DS

 

[Stephen Lebans]

The compressed Images(whatever type Jpg, Gif etc) are stored as Uncompressed
Bitmaps in the OLE field(or if you embedd them in the standard Image
control). Additionally, for OLE embedding, a Presentation stream is created
that is agaain, a copy of the uncompressed Bitmap of the original image.
Basically, double the fun for half the price...translation...do not embed
images as OLE objects. Instead, use the standard Image control and at
runtime, set the Picture property to the full path & Name of the image(s)
you have stored on your disk.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[DS]

The compressed Images(whatever type Jpg, Gif etc) are stored as Uncompressed
Bitmaps in the OLE field(or if you embedd them in the standard Image
control). Additionally, for OLE embedding, a Presentation stream is created
that is agaain, a copy of the uncompressed Bitmap of the original image.
Basically, double the fun for half the price...translation...do not embed
images as OLE objects. Instead, use the standard Image control and at
runtime, set the Picture property to the full path & Name of the image(s)
you have stored on your disk.

Thanks Stephen, I have a standard image control, and under picture I
have the path as such c:\PS\Images\pix.gif
Picture type is embedded, should it be linked? Would that make the
Dbase smaller?
Thanks
DS

 

[Stephen Lebans]

No, even if you link a full resolution uncompressed Bitmap is stored.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[DS]

No, even if you link a full resolution uncompressed Bitmap is stored.

Thanks Stephen,
So if ...
Pix.Bmp 7KB you get 14KB
Pix.Gif 1.5KB you get 3KB ?

Thanks
DS

 

[DS]

Thanks Stephen,
So if ...
Pix.Bmp 7KB you get 14KB
Pix.Gif 1.5KB you get 3KB ?

Thanks
DS

It seems that the way to go after much experimenting and even some
thought is an optimized gif, that is linked to an image control. I also
tried to link it with the forms on current and after update events and
the results turned out to be the same as linking.
Thanks
DS