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

Displaying an image in an ms access report based upon data in a linked MS SQL column (type image)

Posted on 2006-11-08
4
275 Views
Last Modified: 2013-11-28
I have probably missed something really obvious but having spent the last couple of hours trying I could do with some help!

Basically I have a MS Access 2000 database which has a linked table to a MS SQL Server table containing a field of data type image which I want to display on a report in MS Access.

The images within the MS SQL Server table are from a third party system and I do not have access to the original image files.

When I open the linked MS Access table it shows the image data as OLE object.

I have tried using an image object on my report and setting the picturedata property but get an error ("The bitmap you specified is not a device-independent bitmap (.dib) format.

I have also tried using an OLE object but could not see how to set it's properties to use the data contained within the table.

Please can anyone help....(I am meant to be producing a report ASAP with the images in!)
0
Comment
Question by:wilmslowhighcheshire
  • 2
  • 2
4 Comments
 
LVL 7

Expert Comment

by:Jonathan Kelly
ID: 17897617
might be worth checking this out

http://support.microsoft.com/default.aspx/kb/255632
0
 

Author Comment

by:wilmslowhighcheshire
ID: 17897853
Thank you,

Having looked at this, it would at least provide me with a method for creating a file from the image data stored in SQL and then to set the picture property for an image to this file.

It just worries me that as the report could potentially be required to display upto 60 images I would be writing rather a lot of temporary files.
0
 
LVL 7

Accepted Solution

by:
Jonathan Kelly earned 500 total points
ID: 17899343
Hi there,

I dont know if there is another way to achieve this.


I think you need to have an ole server installed in order to deal with the images.

I would try importing a couple of records into an access database. Have a look at the BLOB field - what does it say ?

0
 

Author Comment

by:wilmslowhighcheshire
ID: 17904822
Thank you for this.

The BLOB field says that it is an OLE object.

I think to make my life a little easier I will go with your first solution but write a separate app to store all the images as files in a one-off process and then point the reporting app to these instead.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

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…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

839 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