Apr 16 2022 07:24 PM
Apr 16 2022 07:24 PM
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?
Apr 16 2022 11:55 PM
Try this extension from Microsoft
Apr 17 2022 01:07 AM
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.
Apr 17 2022 09:54 AM
Apr 17 2022 06:25 PM - edited Apr 17 2022 06:58 PM
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
Apr 18 2022 06:02 AM
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.
Apr 18 2022 06:06 AM
Apr 18 2022 04:05 PMSolution
Apr 18 2022 04:36 PM
"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.
Apr 18 2022 09:01 PM
Apr 19 2022 05:57 AM
Apr 19 2022 04:06 PM