TIFF/TIF files not viewable in Access 2003 - why?

[Wade]

I have an image control on a form that is linked (as opposed to embedded) to
either a tif file or jpg file (i.e. the "Picture" property of the control is
set to "C:\image.tif" or "C:\image.jpg") and if the control is linked to a
tif file (doesn't matter what the size of the tif file is - even as small as
35K) I receive the message "Microsoft Office Access doesn't support the
format of the file 'filename.tif,' or file is too large. Try converting the
file to BMP or GIF format.". But if the control is linked to a jpg (I've
used jpg files as large as 2MB) everything works fine. If I convert the tif
file to a jpg, everything works. But merely copying the flt filter from an
Office XP installation (tiffim32.flt) to the Filters folder (c:\program
files\Common Files\Microsoft Shared\Grphflt) where the other filters are,
still doesn't allow the tif file to be viewable in Access 2003.

As mentioned above, tif's and jpg's are both viewable in Access 2002 (XP) -
the tif filter in installed in the graphic filter folder when Office or
Access 2002 is installed, but there is no such filter in Office or Access
2003 - even in the Conversion Pack.

Does anyone know why...
1. MS took this functionality out of the image control in Access 2003?
2. Other than converting to a supported file format, is there any way to
view a tif image in an image control in Access 2003?

 

[Stephen Lebans]

I think the Tiff filter was removed due to security considerations.

An alternate solution is here:
http://www.lebans.com/loadjpeggif.htm
A2KLoadJpegGifGDIPlus.zip is an update to the function to allow for the
Display of Jpeg and Gif files on systems that do not have the Office
Graphic Filters installed. TIF and PNG formats are now supported via the
Microsoft GDI+ DLL. The GDI+ DLL is freely redistributable and available
directly from MS here:

http://www.microsoft.com/downloads/release.asp?releaseid=32738

or on this Web site:

GDI+DLL.zip
Please take a moment to read the redist.txt file contained in
distribution archive. This file explains how and where to install the
DLL.

The GDI+ A2K version can easily be converted to A97 but you will have to
manually change all of the ENUMS. Frankly I am getting tired of
supporting both A97 and A2K versions mainly due to the lack of ENUM
support in A97. :-(

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Wade]

Thanks for the info, I appreciate your response.

Unfortunately, according to the redist.txt file, the dll is not supported on
WinXP systems. It is supported on W2k, NT, & Win98 systems though.

Also, the file doesn't appear to be available at the microsoft web site
anymore, but I think the updated version (which does appear to support XP)
is here (English version):

http://www.microsoft.com/downloads/...9c-df12-4d41-933c-be590feaa05a&DisplayLang=en

...which must go through a validation process before it can be downloaded.

In our situation, it looks like its going to be easier to just convert all
our tif's to jpg's - and hope MS doesn't discontinue support for jpg's too.

 

[Bruce Rusk]

If you have to keep the file in TIFF format (for example because other
software needs to access/edit it), it's not too hard to convert it on the
fly; there's a good freeware control that does this quite quickly-- GFLAx,
part of the GFL SDK available at http://xnview.com

Assuming you're not working with multipage tiffs, you can just convert them
to a standard filename, e.g., tempimg.bmp in the working directory, and
loading that into the control at display time. I've found that the
conversion is fast enough if the files aren't huge and you convert to BMP
(which makes for large files but ones that can be written and read very
quickly since there's no encoding/decoding overhead).

If you decide to convert all your graphics to another format, depending on
what they are and how they're stored within the TIFF file, I'd recommend NOT
converting them to JPGs, because it's a lossy format whereas many TIFF
compression schemes (especially for monochrome images) are lossless, and
TIFF can handle a wider range of color depths (monochrome, grayscale, etc.)
that JPG doesn't. PNG might also be a better choice--it's lossless, and
handles monochrome. JPG is really only suitable for photos and the like, not
for line art, scanned text, or anything with large areas of continuous
color.

 

[Stephen Lebans]

You misunderstand Wade, the DLL is NOT REQUIRED to be distributed to
WinXP systems as it is the same native GDI+ DLL that is found on EVERY
SINGLE XP system.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

I'm not sure I understand. I am using Windows XP, and also want to display
TIF files using Access 2003; I was able to do it before with 2001. So I
downloaded that file, the gdiplus.dll. If I replace my current version of
that file will 1) my system be fine, and 2) will Access be able to view TIF
files?

If "no", then what should I do?

Samir Shah

 

[Bruce Rusk]

No, as I understand it the GDI+ dll that is already in WinXP can handle TIFF
images fine. There is no need to download another one. For example, if you
have TIFF images in a folder and go to the thumbnail view in explorer,
you'll see thumbnails of the TIFFs.

The issue is that, by default, Access doesn't use this DLL to display images
on forms (it uses an image control). What the code of Stephen Lebans' page
does is use the GDI+ dll functionality that is already on your XP system to
display the image in a form. All you need to do is integrate the code form
Stephen's site.

 

[Guest]

I downloaded the Access mdb file from Stephen's website and got it working
now. Thanks for your help everyone.

Samir

 

[Guest]

I tried downloading the microsoft Database that Stephen had on his website,
and tried uploading a .TIF image with it. It gave me an error about an
invalid file type. What am I doing wrong? Any help would be greatly
appreciated.

 

[BoardBurtonVT]

I am having this exact same problem. It seems like the filters built
in to the mdb file that he had on his site do not include the ability
to open .TIF images? It is a neat little application, but I have yet
to see someone give a real explanation about how they have fixed this
problem yet. If Stephen can explain to fix the .TIF image problem
using his code, that would be great.

 

[Stephen Lebans]

Why would you state:

It seems like the filters built
in to the mdb file that he had on his site do not include the ability
to open .TIF images?

The whole point of the GDI+ sample MDB is to add the ability for A2003
to display TIF files.


The workaround to restore the missing Graphics Filters is detailed
below.

1. Stephen Lebans May 27, 8:00 pm show options

Newsgroups: microsoft.public.access
From: "Stephen Lebans"
<[email protected]> - Find
messages by this author
Date: Fri, 27 May 2005 20:00:27 -0300
Local: Fri, May 27 2005 8:00 pm
Subject: Re: .tif Images in Access 2003
Reply to Author | Forward | Print | Individual Message | Show original |
Report Abuse

The Tiff Office Graphics filters(among others) are not installed with
Access 2003. This is a change from all previous versions of Access.
The solution is to get hold of the Office XP Legacy Converter Pack (it
will work for Office 2003 as well). The problem is that you can no
longer download the XP Converter Pack due to security concerns.
http://www.microsoft.com/offic­e/ork/xp/appndx/appc00.htm
Instead you are directed to download the Office 2003 Legacy Converter
Pack but as I said it no longer contains the TIF Filters!!!!aarrgghh
The solution is to contact MS PSS and request the XP Pack.



-----------------------------------------------------------------------
A poster from Germany described the process to obtain the legacy
Graphics Filter pack from MS that does contain the TIFF filters.
Newsgroups: microsoft.public.access
From: "tino" <[email protected]> - Find messages by this
author
Date: Mon, 30 May 2005 06:07:19 -0700
Local: Mon, May 30 2005 10:07 am
Subject: Re: .tif Images in Access 2003
Reply to Author | Forward | Print | Individual Message | Show original |
Report Abuse

Yes, of course, sorry that I did'nt yet :


1. Call the Microsoft Product Support Services
(Phone - No. for Germay : 0180 567 22 55, see Microsoft Sites)
2. Ask for the Hotfix for KB 822346
3. MS will send you a link for Download.


I did so, and there where no more questions for license keys or other,
the
KB - Number was the only necessary information.
__________________________________________________________________





-

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.