Displaying OLE Graphics in a form?

[TABran]

I've created OLE links to graphic files in one of my
databases. Though I did not select "Display as Icon" when
creating the link, and the "display type" property of my
form is set to "Content," the OLE object is still
displayed as an icon. Any suggestions on how to get the
graphic to display in my form? (The liked objects are all
JPG files, which are associated with IE6 on my
workstation. When I double click on the icon, IE opens
fine and displays the image.)

Thanks,

TA

 

[Mike Mueller]

: I've created OLE links to graphic files in one of my
: databases. Though I did not select "Display as Icon" when
: creating the link, and the "display type" property of my
: form is set to "Content," the OLE object is still
: displayed as an icon. Any suggestions on how to get the
: graphic to display in my form? (The liked objects are all
: JPG files, which are associated with IE6 on my
: workstation. When I double click on the icon, IE opens
: fine and displays the image.)
:
: Thanks,
:
: TA

I have only had luck doing this with BMPs.

 

[TA Bran]

Thanks for the reply. Sounds like you've run across the
same problem. Do you think implementing a solution like
that noted in KB Art#285820 would make a difference?

http://support.microsoft.com/default.aspx?scid=kb;en-
us;285820

Best,

TA

 

[Stephen Lebans]

That's a completely different question.
If you want to know what the differences between the 2 methods are, and
why in most cases you should follow the KB article's advice and use a
standard Access Image control, see:
http://www.mvps.org/access/forms/frm0030.htm
and
http://accdevel.tripod.com/

--

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

 

[Exponent]

Note that this approach can still give rise to a huge overhead when working with jpeg images (since certain
OLE server apps store an uncompressed copy of the image in the field, even when linking).

Also, as Stephen mentioned, you'll need to re-create the OLE Links once the right server application is
registered. Furthermore, if the registered application for the relevant file-type is changed (e.g. when
new graphics software is installed) the image handling functionality can be broken again.

You can avoid these problems by storing/generating the image path, and displaying the image in an image
control. The caveats with this approach are that you need to ensure that the relevant office graphics
filters are installed, and workaround the 'scrolling records too quickly while image control is loading
crashes Access' issue, and (optionally) suppress the popup 'Image Loading' progress window.

To avoid these issues you can use something external to display the images that is independent of system
configuration, specific file-type registrations, installed graphics filters etc. Examples include Stephen
Lebans LoadJpegGif (http://www.lebans.com/loadjpeggif.htm) or a commercial component such as our own.

HTH