If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Images In Access
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 |
#2
|
|||
|
|||
Images In Access
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" wrote in message ... 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 |
#3
|
|||
|
|||
Images In Access
Stephen Lebans wrote:
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 |
#4
|
|||
|
|||
Images In Access
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" wrote in message ... Stephen Lebans wrote: 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 |
#5
|
|||
|
|||
Images In Access
Stephen Lebans wrote:
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 |
#6
|
|||
|
|||
Images In Access
DS wrote:
Stephen Lebans wrote: 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 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
What Are The Issues With MS Access Client to SQL Server DB | Smithers | General Discussion | 13 | January 9th, 2006 03:14 PM |
Storing Images In Access - Best Approach | [email protected] | General Discussion | 1 | December 13th, 2005 08:31 PM |
Encrypt AccesS File? | milest | General Discussion | 2 | February 9th, 2005 07:58 PM |
is Access 2003 any better than XP? | Gorb | Using Forms | 2 | November 11th, 2004 09:20 AM |
Access License In Terminal Server | JIM.H. | General Discussion | 9 | July 19th, 2004 12:32 AM |