PA creates jpeg on SQL Server varbinary(MAX) column that is difficult to use from MS Access

[paulbrelin]

I'm using the camera control to create jpeg images and then writing those jpeg files to a SQL Server db in a varbinary(MAX) column. The data is stored as a long text string looking like: "0xFFD8FFE000104A46494600010101....." .  When reading the binary jpeg info back into a PA app screen, all is fine, the image displays.

But reading that same binary jpeg info into an image control in Access does not work. 

Anyone have any suggestions or tips?

[paulbrelin]

This is a long shot but I thought I'd ask... I developed an app that pushes jpeg images from my phone to a SQL Server table. I have the jpeg data from powerapps stored in a varchar(max) field and also varbinry(max) field. 

It works great in PowerApps but now I want to display that jpeg data in an Access DB and have tried all the image/ole/attachment containers without success.

Any ideas?

Thanks in advance.

p

[v-micsh-msft · Accepted solution]

Image control under Microsoft Access is not supported to display hte Jpeg image file type.

What you may take a try is to generate a image file path, then use in with the URL proeprty of the image control under Microsoft Access.

How to display images from a folder in a form, a report, or a data access page

Regards,

Michael

[paulbrelin]

I ended up writing an HTML file writing an HTML file wrapper around the iamge data stored in SQL Server then assiging that file name and location into the web-browser controlsource property. It works fine. Thanks!