Problem Inserting Images into Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For months I have been successfully putting jpeg images (using Insert Object
and selecting the file) into my Access 2000 database. All of a sudden when I
tried to do that I got the filename listed instead of the image. I thought it
might be a size problem, so I made a greatly reduced copy of the database
(with most images deleted) and I still get the same thing. Each jpeg image is
about 25KB in size. Still thinking that it might be a memory problem, I just
accessed to Access 2003 and still have the same problem. Any ideas?

Charles
 
I just accessed to Access 2003 and still have the same problem. Any ideas?
Click to expand...

Do you mean upgraded ?

Office 2003 uninstalls the application that you were probably using as an 'OLE Server' for JPEG images,
i.e. MS Photo Editor. Alternatively, if you installed an application that 'took over' the file registration
for .jpg then you would have the same problem. Open the table and check what is displayed in the relevant
field to see which application you were using.

You can usually fix this by reinstalling MS Photo Editor from the Office XP CD. Note, however, that this
is just one of the drawbacks of OLE Embedding for image storage; others can include a huge storage overhead,
typically between 20 and 200 *times* the original filesize for JPEG. Using OLE Embedding with images is
not the way to future-proof your application.

You'll find more about the disappearance of photo editor here:

"What happened to Photo Editor?"
http://office.microsoft.com/en-us/assistance/HP011454871033.aspx

and here:

"Photo Editor is removed when you install Office 2003"
http://support.microsoft.com/?kbid=817095

and info about the problems with OLE Embedding here:

"Pictures in Access Forms & Reports - OLE Object Photo & Image Problems & Solutions"
http://www.ammara.com/articles/accesspictureole.html

--
_______________________________________________________
http://www.ammara.com/
Image Handling Components, Samples, Solutions and Info
DBPix 2.0: Add pictures to Access, Easily & Efficiently
 
I did mean upgrade. Thanks for the help. I've downloaded DBPix and will try
it out. Looks like OLEs are a deadend and more trouble than they're worth. I
was wondering why my database was getting so big adding small pictures.
Thanks again.

Charles
 
I've been trying to figure out this whole storing pictures as well Charles!
It seems that the most common response is to link them, that way all you are
saving in your database is just a file path to the photo itself.
Just have an unbound Image control and point it to the image path.
For example, on a form you could have a hidden text box that contains the
path D:\MyStuff\Pictures\Photo.jpg
and with a little code your image control would display that picture!
It kind of sounds simple, but im having a heck of a time working out all the
kinks.
Don't know if that will help or not, but it will save you a bunch of space!

-Jeff
 
Back
Top