INSERTING IMAGE LINKS

[sljack63]

I've searched and searched but cannot find an answer for this question:

I want to associate an image file for each records in my db. On the
form displaying the records, I want to add a button that when clicked,
will open up the image using the program associated with it. Currently
the images are stored as jpegs and Microsoft Office Picture Manager is
the program associated with these files. Please note, that I do NOT
want to store the images within the database as it is my understanding
that this will cause the db to bloat, nor do I want to display the
image on the form.

I tried inserting a hyperlink field into the table the form is based
on, but when I click on the hyperlink in the form, access tells me it
cannot open the file (fyi, Firefox is my default browser, but I tried
opening the image using Firefox directly and it works!?!).

I've also tried inserting a OLE object field in the table, but this
didn't work. I could insert an object(image) into the first record,
but when I attempted to insert the next object(image) into the next
record, the db cannot find any images/files in the folder I have them
stored. Method: Click Insert Object | Create from File | Browse
----> The popup window does not display my files?? Is this because
they are jpegs and not bmps?

Can someone please provide me with a step-by-step solution? Thanks in
advance.

 

[sljack63]

FYI - I am using Access 2000 (and if it is relevant I also have Office
2003 [student/teacher ed.] installed.

 

[Larry Linson]

FYI - I am using Access 2000 (and if it is relevant
I also have Office 2003 [student/teacher ed.]
installed.

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

 

[S Jackson]

Thank you so much. I did find a knowledgebase article that helped me as
well:
http://support.microsoft.com/kb/285820/en-us

FYI - I am using Access 2000 (and if it is relevant
I also have Office 2003 [student/teacher ed.]
installed.

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