473,320 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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.

Jun 13 '06 #1
7 10067
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
<ne***********@gmail.com> wrote in message
news:11*********************@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.

Jun 13 '06 #2
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:
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
<ne***********@gmail.com> wrote in message
news:11*********************@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.


Jun 14 '06 #3
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

<ne***********@gmail.com> wrote in message
news:11*********************@f6g2000cwb.googlegrou ps.com...
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:
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
<ne***********@gmail.com> wrote in message
news:11*********************@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.
>

Jun 14 '06 #4
bob

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

ne***********@gmail.com wrote:
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.


Jun 15 '06 #5
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:
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

ne***********@gmail.com wrote:
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.


Jun 15 '06 #6
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:
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

<ne***********@gmail.com> wrote in message
news:11*********************@f6g2000cwb.googlegrou ps.com...
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:
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
<ne***********@gmail.com> wrote in message
news:11*********************@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.
>


Jun 15 '06 #7
This is what solved it. Installing Microsoft Photo Editor fixed the
problem. Thank you!

bob wrote:
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

ne***********@gmail.com wrote:
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.


Jun 16 '06 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: dave | last post by:
Hello there, I am at my wit's end ! I have used the following script succesfully to upload an image to my web space. But what I really want to be able to do is to update an existing record in a...
2
by: John Fryatt | last post by:
Hi, Before I go on, let me just say I'm fairly new at this so excuse me if I say the wrong thing or use the wrong term. Anyway, what I am trying to do is to set up something where I can have a...
4
by: moondaddy | last post by:
Using vb.net I need to download image files to the client browser where they can save to disk. Below is some sample code I'm using. when I run this the File Download window in the browser says: ...
3
by: meyvn77 | last post by:
Hello - I am looking for the best way to store images in a Access DB. My Idea - I have a table with 150,000 records. These recoreds represent a Crash (Traffic Accident). I have 50 different...
13
by: salad | last post by:
Hi Guys: I was stuck. I needed to send a report to a file. My beautiful report(s) in Access were going to require loss of formatting with RTFs, a PITA in WordMailMerge, sending it as a text...
1
by: gm | last post by:
Hi; I have written a database that tracks all the installation we have ever done. I have a small heating company. I have recently started keeping a directory of digital photographs of the...
9
by: Wayne Smith | last post by:
I've come up against a major headache that I can't seem to find a solution for but I'm sure there must be a workaround and I would really be grateful of any help. I'm currently building a web...
5
by: Nathan Sokalski | last post by:
I have a FormView control in which I use a PagerTemplate. I am having trouble accessing the controls in the PagerTemplate. How do I access them, and in what event should I put the could that...
5
by: sukatoa | last post by:
I don't know where to put this thread exactly, but i just want some recommendations about my problem.... I wonder why some of my GIF images doesn't show on my page..... May i know what should...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.