Linking digital images in Access

M

mark

I am trying to develop a database for digital images. Originally I had
problems getting Access to communicate with an OLE server for jpegs so I
installed Microsoft Photo Editor and solved my initial problem. But I
created a new problem because Photo Editor (now discontinued) cannot support
large images (greater than 32 MB of memory). Can I change the OLE server
that Access is trying to communicate with? Can anyone offer any other
solutions to my problem?
 
L

Larry Linson

Bound OLE frames will use the COM-automation-enabled software that is
registered in the user's system for the image file type embedded in or
linked by the OLE Object. Unless what you have encountered is an OLE rather
than a Photo Editor limitation, simply installing another image processing
software package with the capability you want should reregister. (Just about
every software package on the market assumes that you want _it_ to be
registered for every file type it handles.)

Larry Linson
Microsoft Access MVP
 
M

mark

Thank you for responding Larry. I did remove MS Photo Editor and register a
new OLE server but ended up abandoning the OLE Object approach altogether
when I saw that Access was actually embedding and bloating, rather than
linking, and still could not display large images in the OLE controls.

I tried using code to call the images from their external locations but
ultimately ran into the same problem when Access could still not handle the
larger images in the image control boxes. So far the DBPix 2.0 evaluation
program has been the only work around I have found for this problem of
linking to high-res, high color depth scanned images, and appears to be a
costly and programming-intensive solution.
 
M

mark

I have displayed images of up to about 1MB without problems but I have not
been able to display my largest images of 4.5MB within image control boxes.
It appears to be a problem within the Access (XP/2002) controls. I know the
obvious solution is to re-size the images but I am trying to manage high
resolution photo restoration and retouching projects with alot of associated
custom metadata and this would defeat my purpose.
 
Top