Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Acess 2007 and tif images

Posted on 2009-05-05
11
1,184 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
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 functions 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 Ac…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

791 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