Linking digital images in Access

[Guest]

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?

 

[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

 

[Guest]

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.

 

[Stephen Lebans]

I see no such size limitiation here with A2K or higher and WIn2K or
higher. What is the size of the images you are trying to load?

--

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

 

[Guest]

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.

 

[Stephen Lebans]

I can load a 3000 x 2400 uncompressed 24MB Image here with WinXp and
A2k, A2K2 and A2003. Are you working with JPEG Images? Can you Email me
the one that consistently fails and I will give it a try here.

You might also want to have a look here:
http://www.lebans.com/loadjpeggif.htm

--

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