How do I display linked TIFF images within Access 2003 reports?

[Case Cybermancer]

I have developed an application using Access 2002 and it now needs to be
migrated to Access 2003. I generate a number of reports having a list of
individuals' details and their associated photos -- these images can only be
provided in TIFF format and will be frequently updated.

In Access 2002 all works as expected without errors. In Access 2003 it
complains that the TIFF format is not supported and that I should convert
the
images to BMP or GIF. As the images will be frequently updated, batch
converting a few thousand images every couple of days is not a viable
option.

Oddly enough, I can insert the link to a TIFF image into Word 2003 and
PowerPoint 2003 without a problem. Unfortunately, not in Access 2003!

Any useful input will be greatly appreciated.

TIA

 

[SusanV]

http://www.lebans.com/loadjpeggif.htm

 

[Case Cybermancer]

Hi SusanV,
I've looked at http://www.lebans.com/loadjpeggif.htm and a several other
pages on the site. Unfortunately as far as Access goes, they only have info
regarding jpeg and gif images. As for tiff the site simply states that it is
supported via the Microsoft GDI+ DLL. I've downloaded it and tried
installing it according to the instructions (and then some alternate ways).
No difference -- the problem continues...

I there something I've missed?

 

[Case Cybermancer]

Are these multi page TIFF files by any chance? My code only supports single
Image Tif files.

The solution on my site was tested with A2003

Hi Stephen!
These are single page uncompressed TIFFs. Unfortunately the client's
legacy app only outputs TIFF files. As they wish to run interim reports
every evening, I wish to avoid eventually having to batch convert a few
thousand photos at a time.

After trying a few alternatives, I tried adding the GDIplus DLL but it
made no difference. I also tried adding the tiff filter from the
previous version of Access but that also had no effect.

Possibly, I am not asking the right question. Since a full-installation
of "vanilla" MS Access 2003 does not support loading TIFF files into an
image control then what do I need to load onto the current windows or ms
access environment to enable it to do so?
I am now considering to try to add an activex control to the report. Any
ideas of any freeware or functional trial activex controls I can try.

Many thanks,
Case

 

[Case Cybermancer]

Can you send me the TIF file that failed to load? I have never heard yet of
my GDI+ based solution failing to load a single page TIF file. I'd like to
step through the code and see where it is failing with this file. By the
way, as the instructions clearly state, you only need to install the GDI+
runtime on pre windows XP installs that currently do not have the GDI+
libraries installed.

Hi Stephen
I've send you a sample of TIF file directly at the email address I found
at your website. I initially tried posting it to the newsgroup but the
news server was complaining about the file size. Although it could be
split and reassembled I thought it best to give you an non-manipulated copy.
Regards,
Case

 

[Case Cybermancer]

The Tif file you sent loaded perfectly the first time I tried it. Are you
sure you sent me the one that is failing on your system?

What version of WIndows are you running?
What version of Access are you using?

The Tif file you received definitely fails. The target PCs are setup with:
Microsoft Windows XP Professional version 2002 SP2 (French - OEM)
Microsoft Office Professional 2003 (French)
with Microsoft Office Access 2003 (11.5614.5606)
with VBA v 6.04

My laptop is loaded with Windows XP and MS Office Prof 2002 -- my code
and your code works flawlessly on the laptop -- none of the tif's work
on any of the PCs (which are all loaded with Office 2003)

As a last resort I decided to load MS Office XP (i.e., 2002) on one of
the PCs so that I can at least generate one copy of the report -- let's
consider it an upgrade to the previous version
Well, the report is generated in Access 2002 on the PC without any
problems. After installing the older version of Access, I went back to
re-test the report in Access 2003 -- to my surprise, the report now
works in both versions :-o (although in Access 2003 it occasionally
generates an error... not sure why)

 

[Rodrigo T]

Hello Case and Stephen

I am having exacttly the same problem you guys have been talking about.
Access 2003 says it does not support .tif images.
I looked at the PC and found out that it already has de DLL instaled. I do
not have Access 2002 to install here and test.
What else should I do?
Regards,

Rodrigo