Images in Access 2003 forms

  • Thread starter Thread starter Colin
  • Start date Start date
C

Colin

Hi

This is my 2nd post on this topic. I would be very grateful for any help.

I have a number of database files which serve as catalogues of items.
I save the records with individual images (jpg files) displayed in forms
This uses OLE object as data type & then Insert Object in the form.

Everything works fine in both Access 2000 & XP.
However, in Access 2003 it no longer works.
New image files are shown as an Object & have to be double clicked to
display properly.
This is useless.

I have tried this using both Access 2000 file format (default) & the 2002/3
file format. Same result.

I can't just use Insert Image control as each record would display the same
image.

The only response to my previous post suggested I needed Photo Editor to be
reinstalled.
This isn't supplied in Office 2003 & has been superceded with Picture
Manager.
I have tried reinstalling it from the XP CD but it won't install unless I
also reinstall some of the main Office programs.

How do I get the images do display correctly in the form?

Colin
 
Since you really did not explain _how_ you are trying to display the images,
it's hard to diagnose. I can say that the sample database for Access 2000
(and later) at http://accdevel.tripod.com illustrates three approaches to
handling images in Access and has worked for me in Access 2003.

Larry Linson
Microsoft Access MVP
 
Hi

This is my 2nd post on this topic. I would be very grateful for any help.

I have a number of database files which serve as catalogues of items.
I save the records with individual images (jpg files) displayed in forms
This uses OLE object as data type & then Insert Object in the form.

Everything works fine in both Access 2000 & XP.
However, in Access 2003 it no longer works.
New image files are shown as an Object & have to be double clicked to
display properly.
This is useless.

I have tried this using both Access 2000 file format (default) & the 2002/3
file format. Same result.

I can't just use Insert Image control as each record would display the same
image.

The only response to my previous post suggested I needed Photo Editor to be
reinstalled.
This isn't supplied in Office 2003 & has been superceded with Picture
Manager.
I have tried reinstalling it from the XP CD but it won't install unless I
also reinstall some of the main Office programs.

How do I get the images do display correctly in the form?

Colin
Click to expand...

Hi Colin,

You really only have two options to resolve this issue. One is to install
an OLE Server that can render jpg files. As suggested in a previous
response, Photo Editor is one option if you have the Office XP CD.

A second option is to re-architect the way you display your pictures.
Rather than embedding them into your database and using OLE to display
them, you can store the pictures in a folder and display them using the
image control. Doing this does require some code.

Both solutions are explained in the following KB article:

832508 Images That Are Stored in OLE Object Fields Do Not Appear Correctly
http://support.microsoft.com/?id=832508.

--
Regards,
Mike Wachal
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Hi Larry

Sorry but I thought I had explained this clearly.

My table design has a field called picture which is an OLE object data type.
A form is created based on the table.
For each record in the form, I insert the photo by right clicking & then
using Insert object.

This had worked fine in previous versions of Office including 2000 and XP
but no longer worked in Access 2003 for new data records although previous
data still worked fine.

After positng the message, I managed to reinstall Photo Editor from the
Office XP CD.
All now works perfectly again.

However, Photo Editor isn't installed with Office 2003. It has been replaced
with the supposedly more powerful Picture Manager. This looks good but
clearly isn't an OLE server.

Looks like an MS cock-up to me

Colin
 
There is, of course, no substitute for having an COM-automation-enabled
server app registered for the file type if you choose to use OLE Objects and
Bound OLE Fields. I rarely use OLE Objects for pictures, and always have
some image processing software registered, so this is not a problem I have
ever faced.

Strange that a "better" Microsoft image handling program would not be
automation-enabled. Perhaps it just is not registered for the file type --
have you tried registering it?

Larry Linson
Microsoft Access MVP
 
Yes I had registered all file types with the new Picture Manager. It doesn't
do a thing!
I have since read that is recognised as an issue by MS & one solution is to
reinstall Photo Editor!
But what happens if the user doesn't own Office XP or 2000?

Can you please explain to me in simpler language what a
"COM-automation-enabled
server app" means. I assume you don't mean anything as simple as an image
editing program.
I have Paint Shop Pro 8 installed & Macromedia Studio MX suite ...so I think
that covers your point

I realise that using OLE objects for pictures bloats file sizes but I don't
understand how to use the alternative methods of displaying image files in
Access forms.

Colin
 
Back
Top