Go Back   Access World Forums > Apps and Windows > Other Software

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-24-2018, 05:21 AM   #16
BeeJayEff
Newly Registered User
 
Join Date: Sep 2013
Location: Somerset, UK
Posts: 198
Thanks: 37
Thanked 10 Times in 10 Posts
BeeJayEff is on a distinguished road
Re: Viewing RAW files in Access - codec ?

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.

BeeJayEff is offline   Reply With Quote
Old 09-24-2018, 05:25 AM   #17
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,839
Thanks: 55
Thanked 2,183 Times in 2,094 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Viewing RAW files in Access - codec ?

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.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
BeeJayEff (09-24-2018)
Old 09-24-2018, 05:27 AM   #18
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 7,344
Thanks: 92
Thanked 1,809 Times in 1,684 Posts
isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light isladogs is a glorious beacon of light
Re: Viewing RAW files in Access - codec ?

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.

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 09-24-2018, 05:31 AM   #19
theseus
Newly Registered User
 
Join Date: Aug 2018
Posts: 19
Thanks: 1
Thanked 1 Time in 1 Post
theseus is on a distinguished road
Re: Viewing RAW files in Access - codec ?

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?
theseus is offline   Reply With Quote
Old 09-24-2018, 07:35 AM   #20
BeeJayEff
Newly Registered User
 
Join Date: Sep 2013
Location: Somerset, UK
Posts: 198
Thanks: 37
Thanked 10 Times in 10 Posts
BeeJayEff is on a distinguished road
Re: Viewing RAW files in Access - codec ?

Quote:
Originally Posted by theseus View Post
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.
BeeJayEff is offline   Reply With Quote
Old 09-24-2018, 07:40 AM   #21
theseus
Newly Registered User
 
Join Date: Aug 2018
Posts: 19
Thanks: 1
Thanked 1 Time in 1 Post
theseus is on a distinguished road
Re: Viewing RAW files in Access - codec ?

Quote:
Originally Posted by BeeJayEff View Post
... I'd like to exercise and extend my Access knowledge.

An excellent reason!
theseus is offline   Reply With Quote
Old 09-24-2018, 09:57 AM   #22
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,839
Thanks: 55
Thanked 2,183 Times in 2,094 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Viewing RAW files in Access - codec ?

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

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
BeeJayEff (09-24-2018)
Old 09-24-2018, 11:53 AM   #23
BeeJayEff
Newly Registered User
 
Join Date: Sep 2013
Location: Somerset, UK
Posts: 198
Thanks: 37
Thanked 10 Times in 10 Posts
BeeJayEff is on a distinguished road
Re: Viewing RAW files in Access - codec ?

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

BeeJayEff is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Viewing files content inside MS-Access form wegidio Forms 4 01-15-2018 03:54 PM
Question Editing, Viewing Toolbars, Viewing "Access Options", etc... skilche1 General 2 06-17-2009 08:07 AM
Access 2.0 Viewing Code Wollydog Modules & VBA 1 12-03-2008 06:16 AM
Viewing PDF files from within access Beacher Forms 1 06-30-2005 10:45 AM
[SOLVED] Viewing reports in Access pete moss Reports 5 09-05-2004 06:46 PM




All times are GMT -8. The time now is 12:40 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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