Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   Other Software (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=59)
-   -   Viewing RAW files in Access - codec ? (https://www.access-programmers.co.uk/forums/showthread.php?t=301579)

BeeJayEff 09-23-2018 12:25 AM

Viewing RAW files in Access - codec ?
 
I'm implementing an Access database to catalogue a load of old slides. I know there are other products out there which will do that, but a) I'm too tight to buy anything for this and b) I want the learning experience.

One of my main drivers here is that I want to store RAW files only (not jpegs), but I also want to associate keywords with the images.

I am initially photographing the slides using my Canon EOS 70D.

Windows 10 File Explorer is happy to display the thumbnails, so I assume that means I have the required codec. My Access application will display a .jpg file, but not a .cr2 one - does anyone have any ideas why that might be the case - and more importantly, how to resolve it ?

isladogs 09-23-2018 12:53 AM

Re: Viewing RAW files in Access - codec ?
 
There are a myriad of image file formats, not all supported by Access or indeed by specialised image software

According to this article https://fileinfo.com/extension/cr2, cr2 files are based on the tiff format.

Unfortunately, I don't think tiff files are accepted either....????

Try renaming one as tiff and see if that does work.
If not, it's likely you will need to convert to a supported file format

Gasman 09-23-2018 12:59 AM

Re: Viewing RAW files in Access - codec ?
 
You could try this app?
https://www.microsoft.com/en-gb/p/ra...ot:overviewtab

There is some code on this forum that allows one to open any file that has its type registered to the o/s. Use that in conjunction with the Raw Viewer?

I did a quick search, but could not locate it though, sorry.

arnelgp 09-23-2018 01:17 AM

Re: Viewing RAW files in Access - codec ?
 
acan you use the web browser control. it will open whatever its assiciation.

isladogs 09-23-2018 01:58 AM

Re: Viewing RAW files in Access - codec ?
 
Quote:

Originally Posted by arnelgp (Post 1592528)
acan you use the web browser control. it will open whatever its assiciation.

Good point!
Just tested. You can also open tiff files using the standard image control in Access.
Not listed in the file format list, so select all files and browse to the file. Try that for your CR2 files as well.

BeeJayEff 09-23-2018 02:25 AM

Re: Viewing RAW files in Access - codec ?
 
Web browser control looks promising, though it opens the file in Photos, rather than on the form - which is not the end of the world, but not ideal. Also have to convert the file location to a URI, which will be cumbersome.
Having the CR2 file as the control source for a normal image control doesn't work.

isladogs 09-23-2018 03:38 AM

Re: Viewing RAW files in Access - codec ?
 
Quote:

Originally Posted by BeeJayEff (Post 1592535)
Having the CR2 file as the control source for a normal image control doesn't work.

Did you try renaming as TIF?

BeeJayEff 09-23-2018 03:52 AM

Re: Viewing RAW files in Access - codec ?
 
Quote:

Originally Posted by ridders (Post 1592540)
Did you try renaming as TIF?

Yes - no joy.

isladogs 09-23-2018 05:59 AM

Re: Viewing RAW files in Access - codec ?
 
2 Attachment(s)
Quote:

Originally Posted by BeeJayEff (Post 1592535)
Web browser control looks promising, though it opens the file in Photos, rather than on the form - which is not the end of the world, but not ideal. Also have to convert the file location to a URI, which will be cumbersome.
Having the CR2 file as the control source for a normal image control doesn't work.

Use an ActiveX web browser control and it can open local files within the browser window as long as there is a file handler app associated with it.

Surprised arnelgp didn't mention his own example file viewer based on this idea https://www.access-programmers.co.uk...d.php?t=297837

OR try my image viewer app attached

Finally here's another link you may find useful https://www.lifewire.com/cr2-file-2620376

BeeJayEff 09-23-2018 09:48 AM

Re: Viewing RAW files in Access - codec ?
 
I don't have a problem displaying jpgs on Access forms, and I don't have a problem with converting cr2 files to jpgs (I just use the Canon DPP software), but I don't want to have to do that as a separate step for every image.

I really just want to get a thumbnail of the cr2 on an Access form. Given that Photos is the default app for the .cr2 file type, is arnelgp's approach the one I should pursue (this will take some study to understand) ?

isladogs 09-23-2018 10:18 AM

Re: Viewing RAW files in Access - codec ?
 
If you do convert I would recommend avoiding the lossy JPEG format as Access doesn't handle it very well. BMP, PNG, GIF are all OK.

You can get converters that will manage multiple files at once e.g. all files in a folder

I can't say whether using an ActiveX web browser control is the best solution though it should work. I don't have any files in the format you are dealing with.

If you can upload a sample file, I'm willing to try it.

BeeJayEff 09-24-2018 01:51 AM

Re: Viewing RAW files in Access - codec ?
 
Colin - I cannot attach a .cr2 file as an upload as it's not a recognised file type, so I have sent one to the email address in your footer. But it's 25MB, so whether it gets through remains to be seen !

isladogs 09-24-2018 02:30 AM

Re: Viewing RAW files in Access - codec ?
 
You could have zipped it!
No it hasn't come through by email - size limit is much less than that!

However, Access is very unlikely to cope with image files of 25 MB even if it's a recognised file type. So I think you will need to reduce the image dimensions which will also reduce file size

BeeJayEff 09-24-2018 05:15 AM

Re: Viewing RAW files in Access - codec ?
 
Aah, I think we might be at cross-purposes. The whole point of a RAW file (CR2 in Canon's case) is to capture the image as seen by the camera's sensor, so a 20 Megapixel sensor (as in the 70D) will result in 20MB data at 8-bit depth per pixel - and it can be up to 24 bits per pixel (one byte each for R, G and B).

It is the original file which I want to view, so if Access won't cope with that, I shall just stick with having it fire up MS Photos as a separate process. Which is OK, but I shall have to work out if I can get rid of the File Download dialog box and how to kill off that process when moving to view the next image.

arnelgp 09-24-2018 05:17 AM

Re: Viewing RAW files in Access - codec ?
 
look at this link it will convert raw image to any format:

https://www.sno.phy.queensu.ca/~phil/exiftool/


All times are GMT -8. The time now is 06:48 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World