Solved

TIFF Graphics Filter not working in Access 2003

Posted on 2004-09-14
10
774 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
 
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

896 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

12 Experts available now in Live!

Get 1:1 Help Now