Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rauken
Posting Yak Master
108 Posts |
 Posted - 2005-04-21 : 08:41:03
|
| The subject is my problem. I have a web application with a number of tables in sql server. One of the tables holds jpg images related to a product. It works fine showing on the webpage. Now the client wants to use Access to more easily create reports. Using linked sql tables in access workes fine, creating the report works fine except.. getting that picture from sql server into my access report. How should you do it? I've looked everywhere for an solution. I realize that I must store the jpg image locally on the computers using the access application. I don't want to write down all images stored in the database, that's too many mb, just the images for the actual report.The webservers are in a cluster, that's the reason for storing images in sql server. Any help? |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-04-21 : 09:41:41
|
| You can keep the images on SQL server (note if there are many you may want to store them on the server and access them with a table storing the path).The report will only need to access via a bound object frame.JimUsers <> Logic |
 |
|
|
Rauken
Posting Yak Master
108 Posts |
Posted - 2005-04-21 : 10:13:43
|
| bound object frame is using ole right? Are you sure you can bind binary fields from sql server in access? |
|
|
|
Rauken
Posting Yak Master
108 Posts |
Posted - 2005-04-21 : 10:16:54
|
| I've solved my problem. On open event in my report I create a recordset with dao based on the recordsource in my report. I loop all records sending some paramters to a function which creates the image locally on the disk. I use the image control and on the current event I set the picture property to my path to the created picture :-)On close report I delete all created pictures to save diskspace. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-04-21 : 10:18:02
|
| Make it easy.Do not use linked tables.Instead use a .adp Access front end.Create a SP for the backend of the report.JimUsers <> Logic |
|
|
|
|
|
|
Images in Sql Server - Access front end