Answered

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

(0) Share

Report

Posted on by 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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

paulbrelin 26 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
paulbrelin 26 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No