Solved

Acess 2007 and tif images

Posted on 2009-05-05
11
1,183 Views
Last Modified: 2012-05-06
Is there not some simple download somewhere that enable tif images in Access 2007? I know that 2007 and can display tifs because I have one laptop with multiple versions of Access on it and Access 2007 displays the tifs, but on another computer where only the 2007 version is installed, it doesn't display tifs. This has nothing to do with file association either because I can double-click a tif file and have it open up in Windows Picture and Fax Viewer.
0
Comment
Question by:Mach1pro
  • 6
  • 4
11 Comments
 
LVL 75
ID: 24309420
Have you seen this:

http://www.ammara.com/  DBPix ...

I can totally vouch for this program.  

It does all the work for you. Examples show how to add a simple 'control' panel to Load, Save, Zoom In/Out, Size To Fit and much more.  AND ... virtually eliminates BLOAT associated with storing images in an Access MDB. I have 3 clients who sell commerical run-time products that use DBPix.

Note. I have no connection with DBPix ... except I have used it many times ...

mx
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 24309512
The new MS Access 2007 attachments field type supports TIFF directly.  Consequently, there is no need to download and install the graphics filters from the converter pack.   Doing so will likely crash your applications that rely on the TIFF Graphics Filter (see below).  If you have installed the converter pack, then it seems logical to uninstall it.

It is my understanding that the Office Converter pack (which contains the graphics filters) was found to contain a bug which could potentially pose a security threat, so the XP version (which includes the TIFF filter) was withdrawn from Microsoft downloads and replaced with the 2003 version (which does not include TIFF support).
0
 
LVL 6

Author Comment

by:Mach1pro
ID: 24310229
Removing the converter pack doesn't make any sense to me because the TIF filter isn't listed in the filters any.  If you try to add all the graphic filters in 2007, TIF is not an option.  It just doesn't make sense to me that on a computer that had a previous version of Access installed, the tif format is listed in Graphic Files in the windows browse dropdown list but on a computer that has only had Access 2007 installed, tif is not available in the drop down list.  I do NOT want to use 3rd party utilities unless absolutely necessary.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 24311044
sorry. what I should have said is:
The new MS Access 2007 attachments field type supports TIFF directly.   By using attachments, you store image files in their native formats with no supporting images (e,g, Bit Maps), and you do not need to install additional software in order to view the images from within your database.  Consequently, there should be no need to download and install the graphics filters from the converter pack. Further, even if you did install them, the graphics filters do not contain a TIFF filter (it no longer appears on the filter list) as you noted.

So the real question is, with Access 2007, why can't you store the TIFF on the target machine its native format?  
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 24311114
I believe the answer is that you have to use the program that created the image (like Photoshop).
0
 
LVL 6

Author Comment

by:Mach1pro
ID: 24313099
I don't believe you guys are understanding the question. On computer A. Access 2007 is installed. You drop a image control on a form or report. You navigate to a Tiff image on the hard drive. TIF is a graphic option to look for and Access will display it.  ON computer B. Access 2007 is installed. You drop a image control on a form or report. You navigate to a Tiff image on the hard drive. TIF is NOT listed as a graphic option. If you choose All files and select the TIF image, then Access will generate an error when the form or report is opened in anything other than design view. The only obvious difference between computer A and computer B is that computer A also has an earlier version of Access installed. The question is: How do I get computer B to display TIF images in Access without loading a previous version of Access?
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 24313392
Is the problem machine updated through Office 2007 Servce Pack 1?
        http://support.microsoft.com/kb/942378

Among issues fixed by SP1: In Access 2007, the click event for an image control does not work.  
         
0
 
LVL 6

Author Comment

by:Mach1pro
ID: 24314157
All machines using Office 2007 SP1
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 24315197
In Access 2007, In Access 2007, the image control has a Control Source property, so you set the Control Source to the imagepath on the property sheet.  Did you do that?

0
 
LVL 6

Author Comment

by:Mach1pro
ID: 24315494
You cannot even set the control source on the property sheet to a tif file. Access immediately pops an error saying that it is unsupported
0
 
LVL 38

Accepted Solution

by:
puppydogbuddy earned 500 total points
ID: 24316001
Ahaa!!! That is because in Access 2007, by default, MDB databases continue to store images in BMP format to preserve cross-version compatibility. If you know that only Access 2007 client applications will access your database, and you want to take advantage of the new image storage format, you can change the Image cntrol's Picture Property Storage Format by following these steps:

1. Click the Microsoft Office Button, and then select Access Options.
2. Select Current Database, and then select Preserve source image format (smaller file size).
 
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

770 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