I have tried installing the jpg filter from the Office XP CD to display the
contents of my OLE field in a form, but I still can't see my pictures!
bob - 28 Aug 2006 17:38 GMT
To display the content of an OLE Field which contains OLE Embedded or Linked data you need to install the
'OLE Server' application that was used to store the image in the table. You can find out which application(s)
were used to store the data by opening the table and examining the text displayed in the OLE field. The
default/typical application for JPEG is 'MS Photo Editor', in which case you should see something like
"Microsoft Photo Editor 3.0 Photo". In this case you need to install MS Photo Editor from the Office XP
CD’s.
You should be aware that using Photo Editor to store JPEG images in an OLE field incurs a huge overhead
(typically between 10 and 50 *times* the original file-size, and as much as 200 times), as well as a corresponding
performance overhead.

Signature
_______________________________________________________
DBPix 2.0: Add Images to Access, Easily & Efficiently
http://www.ammara.com/dbpix/access.html
>I have tried installing the jpg filter from the Office XP CD to display the
>contents of my OLE field in a form, but I still can't see my pictures!
Roger Carlson - 29 Aug 2006 17:45 GMT
The usual advice is to store not the OLE object itself in the database, but
just the path to the file. Then use an Unbound control and load the picture
at runtime.
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "Picture.mdb" which illustrates how to do this.

Signature
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
> I have tried installing the jpg filter from the Office XP CD to display the
> contents of my OLE field in a form, but I still can't see my pictures!