Access not showing image on the form just the filename

Hi, I have an Access 2002 - 2003 database. I am using Access 2003.
Whenever I link an image all it shows is the filename. Not the image.
Other versions of Access can link the image just fine. The properties
look the same whether I use XP or 2003 versions of Office.

If I take an earlier version of Access and link the image, it puts the
image. I can also see the image in 2003. If I link the image using
2003 it only shows the filename. If I view that same record in lower
versions it also shows the filename. In other words, if I do not
insert the object (link, not embed) with a pre-2003 version, it only
shows the filename. It has the right path and all, just will not show
on the form (other than the name).

Thank you for any help.

re: Access not showing image on the form just the filename

What kind of Control are you using? If it is a Bound or Unbound OLE Frame,
then you need to look also at what program is registered for the type of
image file, because that is what does the displaying in OLE Frames.

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


<needin4mation@gmail.com> wrote in message
news:1150234596.618502.85160@y43g2000cwc.googlegro ups.com...[color=blue]
> Hi, I have an Access 2002 - 2003 database. I am using Access 2003.
> Whenever I link an image all it shows is the filename. Not the image.
> Other versions of Access can link the image just fine. The properties
> look the same whether I use XP or 2003 versions of Office.
>
> If I take an earlier version of Access and link the image, it puts the
> image. I can also see the image in 2003. If I link the image using
> 2003 it only shows the filename. If I view that same record in lower
> versions it also shows the filename. In other words, if I do not
> insert the object (link, not embed) with a pre-2003 version, it only
> shows the filename. It has the right path and all, just will not show
> on the form (other than the name).
>
> Thank you for any help.
>[/color]

re: Access not showing image on the form just the filename

But why would I be able to see the image if another version of Access
inserted the image? It only blows up when the newer version inserts
the image.

Larry Linson wrote:[color=blue]
> What kind of Control are you using? If it is a Bound or Unbound OLE Frame,
> then you need to look also at what program is registered for the type of
> image file, because that is what does the displaying in OLE Frames.
>
> 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
>
>
> <needin4mation@gmail.com> wrote in message
> news:1150234596.618502.85160@y43g2000cwc.googlegro ups.com...[color=green]
> > Hi, I have an Access 2002 - 2003 database. I am using Access 2003.
> > Whenever I link an image all it shows is the filename. Not the image.
> > Other versions of Access can link the image just fine. The properties
> > look the same whether I use XP or 2003 versions of Office.
> >
> > If I take an earlier version of Access and link the image, it puts the
> > image. I can also see the image in 2003. If I link the image using
> > 2003 it only shows the filename. If I view that same record in lower
> > versions it also shows the filename. In other words, if I do not
> > insert the object (link, not embed) with a pre-2003 version, it only
> > shows the filename. It has the right path and all, just will not show
> > on the form (other than the name).
> >
> > Thank you for any help.
> >[/color][/color]

re: Access not showing image on the form just the filename

Is the very same program registered to be automatically used for that image
file type on the computer that has the newer version of Access? One of the
points was that it is not just Access that you are dealing with, but the
image processing/display software that is registered for the image type.

Still, you did not answer my question. We ask questions to try to get enough
information to be of help. It makes a difference _how_ you are trying to
display the image. We do our best, here, to answer specific questions, but a
newsgroup isn't suitable for a lengthy tutorial on image handling -- that is
why I created the examples I referenced, and why others have created
examples of both similar and different approaches.

Now, you say "blows up" but seems, before, you said "just shows the text of
the filename." There's quite a difference between those, in my view.

Larry Linson
Microsoft Access MVP

<needin4mation@gmail.com> wrote in message
news:1150255842.365839.47290@f6g2000cwb.googlegrou ps.com...[color=blue]
> But why would I be able to see the image if another version of Access
> inserted the image? It only blows up when the newer version inserts
> the image.
>
> Larry Linson wrote:[color=green]
>> What kind of Control are you using? If it is a Bound or Unbound OLE
>> Frame,
>> then you need to look also at what program is registered for the type of
>> image file, because that is what does the displaying in OLE Frames.
>>
>> 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
>>
>>
>> <needin4mation@gmail.com> wrote in message
>> news:1150234596.618502.85160@y43g2000cwc.googlegro ups.com...[color=darkred]
>> > Hi, I have an Access 2002 - 2003 database. I am using Access 2003.
>> > Whenever I link an image all it shows is the filename. Not the image.
>> > Other versions of Access can link the image just fine. The properties
>> > look the same whether I use XP or 2003 versions of Office.
>> >
>> > If I take an earlier version of Access and link the image, it puts the
>> > image. I can also see the image in 2003. If I link the image using
>> > 2003 it only shows the filename. If I view that same record in lower
>> > versions it also shows the filename. In other words, if I do not
>> > insert the object (link, not embed) with a pre-2003 version, it only
>> > shows the filename. It has the right path and all, just will not show
>> > on the form (other than the name).
>> >
>> > Thank you for any help.
>> >[/color][/color]
>[/color]

re: Access not showing image on the form just the filename

Are you doing the 2003 and the pre-2003 insertion on the same computer?

Office 2003 does not include an ‘OLE Server’ for JPEG (and if you install 2003 as an upgrade it will remove
the existing OLE Server) – the ‘OLE Server’ is needed to display JPEG (and some other formats) in a Bound
or Unbound object frame.

Most likely you just need to install ‘MS Photo Editor’ from the Office XP CD on your Office 2003 machine.
Note that this will not affect images that you have already inserted which do not display - you would
need to re-insert them after installing Photo Editor.

You should note, however, that even with ‘Linking’ (which you might reasonably expect to only ‘link’ to
the file) there is a huge amount of data stored in the table – often as much as 50 times the size of the
actual file (for JPEG images), so you may find that your database heads rapidly towards the Access file
size limit. Of course this can also have a significant effect on form performance, plus if a user installs
graphics software which takes over the ‘OLE Server’ registration for the particular file-type you can be
back to the same problem.

--
__________________________________________________ _____
DBPix 2.0: Add pictures to Access, Easily & Efficiently
http://www.ammara.com/dbpix/access.html



needin4mation@gmail.com wrote:[color=blue]
>Hi, I have an Access 2002 - 2003 database. I am using Access 2003.
>Whenever I link an image all it shows is the filename. Not the image.
>Other versions of Access can link the image just fine. The properties
>look the same whether I use XP or 2003 versions of Office.
>
>If I take an earlier version of Access and link the image, it puts the
>image. I can also see the image in 2003. If I link the image using
>2003 it only shows the filename. If I view that same record in lower
>versions it also shows the filename. In other words, if I do not
>insert the object (link, not embed) with a pre-2003 version, it only
>shows the filename. It has the right path and all, just will not show
>on the form (other than the name).
>
>Thank you for any help.
>[/color]

re: Access not showing image on the form just the filename

Thanks everyone. I'm still working on it. It is an unbound Image
control. All the settings look right. I also changed the image
display program from the 2003 program to the stock XP program. Same
thing. It just shows the fiename.jpg. I will try and find MS Photo
Editor on the old CD and see if it helps. Thanks again.


bob wrote:[color=blue]
> Are you doing the 2003 and the pre-2003 insertion on the same computer?
>
> Office 2003 does not include an 'OLE Server' for JPEG (and if you install 2003 as an upgrade it will remove
> the existing OLE Server) - the 'OLE Server' is needed to display JPEG (and some other formats) in a Bound
> or Unbound object frame.
>
> Most likely you just need to install 'MS Photo Editor' from the Office XP CD on your Office 2003 machine.
> Note that this will not affect images that you have already inserted which do not display - you would
> need to re-insert them after installing Photo Editor.
>
> You should note, however, that even with 'Linking' (which you might reasonably expect to only 'link' to
> the file) there is a huge amount of data stored in the table - often as much as 50 times the size of the
> actual file (for JPEG images), so you may find that your database heads rapidly towards the Access file
> size limit. Of course this can also have a significant effect on form performance, plus if a user installs
> graphics software which takes over the 'OLE Server' registration for the particular file-type you can be
> back to the same problem.
>
> --
> __________________________________________________ _____
> DBPix 2.0: Add pictures to Access, Easily & Efficiently
> http://www.ammara.com/dbpix/access.html
>
>
>
> needin4mation@gmail.com wrote:[color=green]
> >Hi, I have an Access 2002 - 2003 database. I am using Access 2003.
> >Whenever I link an image all it shows is the filename. Not the image.
> >Other versions of Access can link the image just fine. The properties
> >look the same whether I use XP or 2003 versions of Office.
> >
> >If I take an earlier version of Access and link the image, it puts the
> >image. I can also see the image in 2003. If I link the image using
> >2003 it only shows the filename. If I view that same record in lower
> >versions it also shows the filename. In other words, if I do not
> >insert the object (link, not embed) with a pre-2003 version, it only
> >shows the filename. It has the right path and all, just will not show
> >on the form (other than the name).
> >
> >Thank you for any help.
> >[/color][/color]

re: Access not showing image on the form just the filename

No. It is a different program to view images. Also forgot to say that
it is on two different computers (see message below xp on one, 2003 on
the other). The display is an unbound image control that I am
inserting the link to. I did mean the same thing by blows up. Sorry.
Thanks again.


Larry Linson wrote:[color=blue]
> Is the very same program registered to be automatically used for that image
> file type on the computer that has the newer version of Access? One of the
> points was that it is not just Access that you are dealing with, but the
> image processing/display software that is registered for the image type.
>
> Still, you did not answer my question. We ask questions to try to get enough
> information to be of help. It makes a difference _how_ you are trying to
> display the image. We do our best, here, to answer specific questions, but a
> newsgroup isn't suitable for a lengthy tutorial on image handling -- that is
> why I created the examples I referenced, and why others have created
> examples of both similar and different approaches.
>
> Now, you say "blows up" but seems, before, you said "just shows the text of
> the filename." There's quite a difference between those, in my view.
>
> Larry Linson
> Microsoft Access MVP
>
> <needin4mation@gmail.com> wrote in message
> news:1150255842.365839.47290@f6g2000cwb.googlegrou ps.com...[color=green]
> > But why would I be able to see the image if another version of Access
> > inserted the image? It only blows up when the newer version inserts
> > the image.
> >
> > Larry Linson wrote:[color=darkred]
> >> What kind of Control are you using? If it is a Bound or Unbound OLE
> >> Frame,
> >> then you need to look also at what program is registered for the type of
> >> image file, because that is what does the displaying in OLE Frames.
> >>
> >> 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
> >>
> >>
> >> <needin4mation@gmail.com> wrote in message
> >> news:1150234596.618502.85160@y43g2000cwc.googlegro ups.com...
> >> > Hi, I have an Access 2002 - 2003 database. I am using Access 2003.
> >> > Whenever I link an image all it shows is the filename. Not the image.
> >> > Other versions of Access can link the image just fine. The properties
> >> > look the same whether I use XP or 2003 versions of Office.
> >> >
> >> > If I take an earlier version of Access and link the image, it puts the
> >> > image. I can also see the image in 2003. If I link the image using
> >> > 2003 it only shows the filename. If I view that same record in lower
> >> > versions it also shows the filename. In other words, if I do not
> >> > insert the object (link, not embed) with a pre-2003 version, it only
> >> > shows the filename. It has the right path and all, just will not show
> >> > on the form (other than the name).
> >> >
> >> > Thank you for any help.
> >> >[/color]
> >[/color][/color]

re: Access not showing image on the form just the filename

This is what solved it. Installing Microsoft Photo Editor fixed the
problem. Thank you!

bob wrote:[color=blue]
> Are you doing the 2003 and the pre-2003 insertion on the same computer?
>
> Office 2003 does not include an 'OLE Server' for JPEG (and if you install 2003 as an upgrade it will remove
> the existing OLE Server) - the 'OLE Server' is needed to display JPEG (and some other formats) in a Bound
> or Unbound object frame.
>
> Most likely you just need to install 'MS Photo Editor' from the Office XP CD on your Office 2003 machine.
> Note that this will not affect images that you have already inserted which do not display - you would
> need to re-insert them after installing Photo Editor.
>
> You should note, however, that even with 'Linking' (which you might reasonably expect to only 'link' to
> the file) there is a huge amount of data stored in the table - often as much as 50 times the size of the
> actual file (for JPEG images), so you may find that your database heads rapidly towards the Access file
> size limit. Of course this can also have a significant effect on form performance, plus if a user installs
> graphics software which takes over the 'OLE Server' registration for the particular file-type you can be
> back to the same problem.
>
> --
> __________________________________________________ _____
> DBPix 2.0: Add pictures to Access, Easily & Efficiently
> http://www.ammara.com/dbpix/access.html
>
>
>
> needin4mation@gmail.com wrote:[color=green]
> >Hi, I have an Access 2002 - 2003 database. I am using Access 2003.
> >Whenever I link an image all it shows is the filename. Not the image.
> >Other versions of Access can link the image just fine. The properties
> >look the same whether I use XP or 2003 versions of Office.
> >
> >If I take an earlier version of Access and link the image, it puts the
> >image. I can also see the image in 2003. If I link the image using
> >2003 it only shows the filename. If I view that same record in lower
> >versions it also shows the filename. In other words, if I do not
> >insert the object (link, not embed) with a pre-2003 version, it only
> >shows the filename. It has the right path and all, just will not show
> >on the form (other than the name).
> >
> >Thank you for any help.
> >[/color][/color]