show OLE image type from sql server to ms access report

[farzad]

Hi All
before thanks for making this forum
and taking time to answer my question.

I am using SQL server (ODBC link) in MS access Database , there is one field exist in SQL server table with OLE Image type that I want to show direct in MS access report .
what should I do , I did more search in Google but I didn't find a good solution for this
please help ASAP.
thanks

[ck9663]

It would be better if you put the images in a shared folder and store the image path and filename in SQL Server table.

Good Luck!!!


~~ CK

[farzad]

Hi thanks ch9663 for your response
But it is not possible because we have a software and it designed like this and we cannot change it but just we can use the database as ODBC link in MS access or such as software

any idea please
thanks before

[ck9663]

Did you google enough?

I found this

Happy Coding!!!


~~ CK

[farzad]

yes thanks ch9663 , I saw this site before
problem in that solution is ,
he provide for one by one ole not for continues report
thanks again