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.
7  10082 
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.
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.
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.
>
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.
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.
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.
>
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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:
...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |
