wilmslowhighcheshire
asked on
Displaying an image in an ms access report based upon data in a linked MS SQL column (type image)
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!)
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!)
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
http://support.microsoft.com/default.aspx/kb/255632