Insert .jpg file into Ole Object field record

[Guest]

I want to insert a .jpg file into a record of an OLE field. Existing photos
which were already on the database before it was moved display properly.

When I click on Insert/Object/new the Object Type List reads:


Adobe Acrobat
Bitmap Image
Media Clip
Microsoft Equation
Microsoft Excel Chart
Microsoft Excel Worksheet
Microsoft Graph Cart
Microsoft Powerpoint Presentation
Microsoft Powerpoint Slide
Microsoft Word Document
Microsoft Word Picture
Midi Sequence
Package
Paintbrush Picture
Snapshot File
Video Clip


There is no option to accomodate a .jpg file. What can I do to solve this
problem?

Thank you for whatever help you can provide.

Mary

 

[Guest]

Sorry I dont know, I have a simular problem with a member card with a photo


"sweeneysmsm" skrev:

 

[Gina Whipp]

sweeneysmsm,

If memory serves me correct, unless you Microsoft Phot Editor from a
previous version of Office installed on the machine displaying .jpg's is a
problem. Also of note, is that storing images in OLE field of a table
causes severe bloating issues which could cause your database to reach it's
maximum size limit quickly.

Try looking www.rogersaccesslibrary.com (Picture.mdb) from Roger Carlson's
site as an alternative.

 

[Guest]

If you open the Table object, then dbl click the table name,enter data for
the record, when you get to the column which contains photos, right click,
then click Insert Object. When a window opens, click on Create from File
(instead of Create New), then click on Browse, go to the file your pictures
are in and select the one you want. That's it.

 

[Guest]

Hi, Bellwether5.

I have tried this but when I do what appears in the window is not the photo
but the typed name of the file: eg. sweeney.jpg. I want the photo looking at
me.

 

[Guest]

Hi, Gina,

The database is not that huge. It has maybe 400 records not thousands. The
photo is important to prevent entering information into the wrong record. I
did find a link which might be helpful - http://kb.iu.edu/data/agjf.html.
This article is talking as though I can still find MS Photo Editor in Office
2003 though I have read in other places that this is not the case. I will
look on my installation CD and check. It does seem that in some instances it
would be important to be able to have a .jpg file embedded. I didn't want the
link because if the database gets moved to another place, I am faced with
having to redo all of the links.

Mary

 

[Guest]

I'm a total novice so can't offer much, except it sounds like it's trying to
link to the photos and there is some missing Visual Basic code. If you go to
Design View in Report or Form, and click on View / Code, there would be
appropriate code for linking.
I tried doing the linking process and get the same results you do.

 

[Gina Whipp]

Hi sweeneysmsm,

Microsoft Photo Editor 3.0 was only available in previous versions of
Office. I'm not sure but you can check Microsoft's site.

The link I provided is to a database showing alternative ways to store
images then in the database. The way I do mine is having all the pictures
in one directory that can be updated by the end-user so the path information
is only changed one place for all pictures. If you decided to use this
database on another machine, it too may not have Microsoft Photo Editor 3.0
and you could be in the same situation. Also note, 400 records is nothing
for Access, 400 images stored in an OLE fields may vary well be and you
might even see a performance hit having that many pictures (as well as a
bloat in size).

Good luck on your project!
Gina Whipp

 

[Larry Linson]

"sweeneysmsm" wrote

I have tried this but when I do what appears in
the window is not the photo but the typed name
of the file: eg. sweeney.jpg. I want the photo
looking at me.

When you use OLE (Object Linking and Embedding) Objects and Bound Object
Frames, you put yourself at the mercy of whatever software the user has
registered in the user's system for that image file type. One of the
possibilities is the Microsoft Picture Editor mentioned by another poster,
but that is only one of many, many image processing software packages. There
is a property for OLE Frames that lets you specify that you want to show the
"thumbnail" but, even if you check it, it still depends on the registered
image processing software.

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP