Images storing and viewing

G

Guest

Hi

I'm a sql person but been going some work in access for a bit of fun.

I have this question, I created a field to store an image. I read the help
of access and saw best datatype for this would be OLEOBJ,

So now my datatype is OLEOBJ and I created a form via the wizard, in less
than 30 seconds gotta love it :p

Now I have this problem, when I add my image to the form via insert image,
deselect the checkbox for link only - Only the filename of the object appears.

Is this because I don't have the correct libraries inistalled for access to
view images or how can I get around this problem so that I can actually see
the image ?

Thank you in advance for the help.
 
E

Exponent

Using this approach relies on having a suitable ‘OLE Server’ application installed and registered for the
particular file-type. Configuration problems like this are common with this approach, especially now that
Access 2003/Office 2003 no longer include OLE server applications for several common image formats.

Note also that ‘linking’ may not be doing what you think, and can still give rise to a huge storage overhead
that can be > 100 *times* the size of the image files that you ‘link’ (with embedding, the storage overhead
can be 200 *times* !!!)

If you want to work with external files just store or generate the filename and path.
If you want to store the images in the DB, store raw-binary/blob data rather than OLE Embedding, to avoid
these and other problems.

Some additional info and detail is available here:

Common Access OLE Object Photo & Image Problems (inc Access 2003)
http://www.ammara.com/articles/accesspictureole.html

Efficient Access Image Storage – OLE Linking & Embedding vs raw-binary storage:
http://www.ammara.com/articles/imagesaccess.html

--
______________________________________________________

http://www.ammara.com/
Image Handling Components, Samples, Solutions and Info
DBPix 2.0 - lossless jpeg rotation, EXIF, asynchronous
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top