JPG images (converted from HAIC format by Photos app) on Access form do not display (Error 2245)

[Dibble1]

Hello all

This is my fist time posting on this forum. I was sent here my Microsoft support who could not help me with my problem. I could not find any topics on this subject on this forum so have started a new discussion.

In my Access 2019 database I use lots of JPG images in forms and reports. These all display correctly and there are genereally no issues.

Recently I received some JPG images that were in the new Apple HAIC format. I searched online on how to convert them and the instructions were that you could convert them using Microsoft Photos app. This was correct and I successfully converted the HAIC images using the Photos app to JPG format.

However, when I linked these JPG images into my Access database, they did not display on forms or reports. Instead I received an Error 2245.

Is there an issue with using JPG images converted by Photos app in Access?

[#2]

Try this extension from Microsoft

https://www.microsoft.com/en-us/p/heif-image-extensions/9pmmsr1cgpwg?activetab=pivot:overviewtab

[#3]

Thanks for your response.

I already have this installed and am able to read HEIC format files. However, Access cannot read HAIC files. Therefore I converted it to JPG using Photos. It is these JPG files Acces is not unable to read.

@karenlorr_uk 

[#4]

Can you share one of these images to experiment with?

[#5]

Thanks George
Yes, I can. I can attach the original and the converted jpg, but not sure how I can do this in this forum. The insert Photos option does not seem to work... sorry new here...

OK, worked it out 🙂

Here are the links

HEIC image: https://1drv.ms/u/s!AuLbF6yK_DMMecjYs8wZpHczIGs?e=ZXdkTj

JPG image: https://1drv.ms/u/s!AuLbF6yK_DMMehlG56XGFu7SoFU?e=QDmeDn

[#6]

@Dibble1 

Interestingly, when I open the jpg in the browser, it looks fine. I see a butterfly or moth (not an expert). When I download it and open it on the desktop using IrfanView, it's a black square.

When I try to open the HEIC image in the browser, it returned an error, but then opened it on the second try. However, it too displays only a black square in IrfanView.

I don't know what to make of that.

However, it does suggest this is a problem in the image(s) themselves, which lies outside the Access environment.

You might want to investigate the file properties of these images further, using a tool like this one. 

[#7]

You might also want to visit Apple's support site and see if you can find more information about their image formats. In the past, images I have downloaded from my iPhone are in .jpg format, by the way, so I've not seen this new HEIC format that I am aware of.

[#8 · Accepted solution]

Thanks George
Yes, there is an issue with the JPG created by Microsoft's Photos app.
However, I have now managed to convert the HAIC image to JPG by sending it from the Apple iPhone via Mail. This action automatically converts the HAIC format to a JPG format.
This JPG does not have any issues in Access.

I wonder if this is something that needs to be submitted as an issue to Microsoft Photos app?

[#9]

@Dibble1 

"Yes, there is an issue with the JPG created by Microsoft's Photos app."

Ah, I should have thought of that. Your experience correlates with mine where I upload the images from the iPhone to OneDrive rather than mail, but that does the conversion properly.

Yes, definitely let MS know about it.  It might help. 

[#10]

Not sure how I contact Microsoft about this issue... Any suggestions?

[#11]

I was afraid you would ask before I had found a way. I looked quickly at a couple of places, but saw nothing pertinent to the Photos app. I will continue to look for something today.

There are different forums here in the Tech Community; the closest seems to be the Windows Hub, https://techcommunity.microsoft.com/t5/windows/ct-p/Windows10, which may be relevant because Photos is a Windows App. Otherwise, it probably depends on how ambitious you are about reporting it.

[#12]

Thanks for the link, I will think about doing this