Viewing RAW files in Access - codec ?

[BeeJayEff]

I don't have a problem converting the images - Canon's software is well up to that task. It's viewing the original, preferably on an Access form, that's the issue - but from Ridders' post I take it that that will not be possible.

[arnelgp]

what i mean is you can convert it first using code inside your form and set the Picture property if the image to the converted. then you can view the image.

there is an image codec from ms but unfirtunately it dies not support win 10 so i cannot test.

[isladogs]

The only way to find out is to try it and see.
If you do have to convert it then definitely avoid JPEG as you will lose lots of detail.

[theseus]

How many slides are you converting to put in your database? I have a 70D and don't use RAW often, because the size of the file is so large (24-25 MB). My concern is that with storing a RAW image and possibly a smaller JPG, you will have a massive database.



Just out of curiosity, why aren't you using a program like Lightroom or Bridge to manage your images?

[BeeJayEff]

Originally Posted by theseus

How many slides are you converting to put in your database? I have a 70D and don't use RAW often, because the size of the file is so large (24-25 MB). My concern is that with storing a RAW image and possibly a smaller JPG, you will have a massive database.

Just out of curiosity, why aren't you using a program like Lightroom or Bridge to manage your images?

Probably a couple of thousand 35 mm slides altogether. I will not be storing any images within the Access db, but on an external drive, so a TB drive or bigger should be fine. I will only convert to jpg if and when I need to (many of them are of little interest and/or poor quality), but I want to tag them all and of course that cannot be done within the RAW file.

As to using Lightroom or Bridge, a) that costs money but mainly b) I'd like to exercise and extend my Access knowledge.

[theseus]

Originally Posted by BeeJayEff

... I'd like to exercise and extend my Access knowledge.

An excellent reason!

[arnelgp]

here is a sample db that will convert your .cr2 raw image
to .jpg

i took time to study how this will work.

for this test, copy all files to MyDocuments.
make sure you add to Path the folder where
you put exiftool.exe.

run the db, if security warning allow it to run.
this will create two folder RAW and JPEG.

your .cr2 file will be copied to RAW folder, converted
to .jpg and the .jpg copied to JPEG folder.

the form will open and the path says it is using the RAW
folder while in fact the image being displayed is located
on the JPEG folder.

https://www.dropbox.com/s/agahoqwvef...leRAW.zip?dl=0

[BeeJayEff]

Thanks, arnelgp, I shall study that when I can find some time