cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
paulbrelin
Frequent Visitor

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

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
paulbrelin
Frequent Visitor

Trying to pull jpeg data down to Access forms from Powerapps generated SQL Server table data

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

 

 

Community Support
Community Support

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

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

paulbrelin
Frequent Visitor

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

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!

 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,029)