Solved Image control for printing photos from an sql table

[Bæla]

Hi, strangely enough there is no control in Access for printing photos stored in an sql table.
I have tried Dbpix and Bukrek's, where Bukreks has worked fine until now.
I suddenly get problems when trying to print more than 5 photos in one report.

What is the solution for this problem?

 

[arnelgp]

maybe download a local copy of the image to a folder
and set the picture property of the image control to
the local image file.

 

[theDBguy]

Hi. Just curious, what is the data type of your photo stored in SQL Server?

 

[Bæla]

I have got the answer. I can not bind the field to an image control. I use the Bukrek control, and it works fine. This problem is a memory problem that Bukrek can not solve. The options are
1. print one photo at the time
2. export the report to pdf.

But it is a shame that no such control exist ifor Access report.

 

[theDBguy]

But it is a shame that no such control exist ifor Access report.

I could be wrong, but I think that would depend on what data type the image column is in SQL Server. Can you tell us what that is? (Sorry if you already told us and I missed it.)

 

[Bæla]

Hi. Just curious, what is the data type of your photo stored in SQL Server?

Data type is Ole/db

 

[Bæla]

The photos were taken with a Canon SX 740 camera. More resolution than mobil phone cause the problem.

I could be wrong, but I think that would depend on what data type the image column is in SQL Server. Can you tell us what that is? (Sorry if you already told us and I missed it.)

Ole/db

 

[theDBguy]

Data type is Ole/db

Hi. I'm sorry, which version of SQL Server are you using? I didn't think there was an OLE/DB data type in SQL Server. I usually use VARBINARY(MAX) for images.

Data types (Transact-SQL) - SQL Server | Microsoft Docs

 

[Bæla]

The datatype in SQL Server 2019 is image, displays OLE-object from Access.

 

[theDBguy]

The datatype in SQL Server 2019 is image, displays OLE-object from Access.

Hi. Thanks for the clarification.