Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / August 2006

Tip: Looking for answers? Try searching our database.

display a jpg file in a bound control - can't see image in form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cone - 28 Aug 2006 17:01 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.