Solved

TIFF Graphics Filter not working in Access 2003

Posted on 2004-09-14
10
777 Views
Last Modified: 2007-12-19
For some reason when I specify a path to a linked TIFF file, the image will not display properly.  I get:

"'Run-Time error 2114 'AppName' doesn't support the format of the file 'Z:\path\filename.tiff', or file is too large.  Try converting the file to BMP or GIF format."

I know there is nothing wrong with the file, because I can open it directly by clicking on it.  I have made sure that the file associations in Windows Explorer for TIFF files are set to use Microsoft Document Imaging.  No matter what program I select to open the TIFF files, they will not open with Access.  

I have the TIFFIM32.FLT graphic filter installed in the correct directory.

Any ideas?
0
Comment
Question by:DanielAttard
  • 5
  • 3
  • 2
10 Comments
 

Author Comment

by:DanielAttard
ID: 12061521
My copy of Access does not consider TIFF files to be graphic files.  How can I change this?
0
 
LVL 15

Expert Comment

by:will_scarlet7
ID: 12062707
Daniel,
    How are you trying to access the image on your form? Do you want it linked or embedded?
Sam
0
 

Author Comment

by:DanielAttard
ID: 12063292
the image is linked
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12064191
The filter needs to be registered, not just copied into the directory - try downloading and installing this:
http://www.microsoft.com/downloads/details.aspx?FamilyID=cf196df0-70e5-4595-8a98-370278f40c57&DisplayLang=en
0
 
LVL 15

Expert Comment

by:will_scarlet7
ID: 12065162
Daniel,
    If the link that Shane posted does not help your situation, the only thing I know of that works for sure involves imbedding the image into your database using Word. From my experience Microsoft Access is rather buggy when it comes to dealing with graphics in formats other than .bmp & .jpg and the only sure solution (except with .png) that I have found is to open Word, insert the picture into a new document, then select the image Ctrl+C, switch back to your database and either in a OLE field in a table or directly on your form paste. It is not the best as the images are quite large this way and cause a fair bit of bloating of the database, but it works. (I'm contemplating using a seperate BE database for a project that I am planning just to store .gif files that have tranparencies)

Sorry I couldn't be more helpful.

Sam
0
 

Author Comment

by:DanielAttard
ID: 12067179
Thanks shanesuebsahakarn.  I tried your suggestion and downloaded and installed the Office File Converter Pack, but it looks like the TIFF converter was not included in that pack.  I tried to go into Office setup and specify to include the TIFF filter, but that option is not available.  Perhaps what I will need to do is manually create the registry key for the TIFF filter using regedit, and do it by comparison to a functioning machine.  What do you think?
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12067327
You can do, although I have no idea which registry keys are involved. AFAIK, the TIFF filter is one of the defaults installed with Office (at least, I've always had it) - although I always specify a full install of Office rather than a typical install - that leaves way too many things I need out.
0
 
LVL 15

Accepted Solution

by:
will_scarlet7 earned 500 total points
ID: 12082425
Daniel,
    Do you have a copy of the Office 2000  or XP CD handy? If so I think I may have a solution to your problem. For some reason Office 2003 does not include TIFF in the installable graphics filters (At least not when running the version that I have on my machine, which is using WinXP SP2). However if you have the CD from your previous version of Office, you can run the install and only select the graphics filter for the TIFF image type. It will take about 29 megabytes, but I just did it on my machine and it works fine.

God bless!

Sam
0
 
LVL 15

Expert Comment

by:will_scarlet7
ID: 12086298
Daniel,
 If you'd like to contact to MOD's and get a refund for the points on this question (assuming the answer above worked for this situation as well as the other) since you accepted the same answer in your other post, it's fine with me.

God bless!
Sam
0
 
LVL 15

Expert Comment

by:will_scarlet7
ID: 12087403
ThanX Daniel!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now