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

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-23-2018, 12:25 AM   #1
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
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 ?

BeeJayEff is offline   Reply With Quote
Old 09-23-2018, 12:53 AM   #2
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,928
Thanks: 92
Thanked 1,707 Times in 1,584 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
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
__________________
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-23-2018, 12:59 AM   #3
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,591
Thanks: 308
Thanked 403 Times in 388 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: Viewing RAW files in Access - codec ?

You could try this app?
https://www.microsoft.com/en-gb/p/raw-viewer/9wzdncrdbvl5#activetab=pivotverviewtab

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.

__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is offline   Reply With Quote
Old 09-23-2018, 01:17 AM   #4
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,847
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 ?

acan you use the web browser control. it will open whatever its assiciation.
__________________
"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-23-2018)
Old 09-23-2018, 01:58 AM   #5
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,928
Thanks: 92
Thanked 1,707 Times in 1,584 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Viewing RAW files in Access - codec ?

Quote:
Originally Posted by arnelgp View Post
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.
__________________
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-23-2018, 02:25 AM   #6
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 ?

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.
BeeJayEff is offline   Reply With Quote
Old 09-23-2018, 03:38 AM   #7
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,928
Thanks: 92
Thanked 1,707 Times in 1,584 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Viewing RAW files in Access - codec ?

Quote:
Originally Posted by BeeJayEff View Post
Having the CR2 file as the control source for a normal image control doesn't work.
Did you try renaming as TIF?

__________________
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-23-2018, 03:52 AM   #8
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 ridders View Post
Did you try renaming as TIF?
Yes - no joy.
BeeJayEff is offline   Reply With Quote
Old 09-23-2018, 05:59 AM   #9
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,928
Thanks: 92
Thanked 1,707 Times in 1,584 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Viewing RAW files in Access - codec ?

Quote:
Originally Posted by BeeJayEff View Post
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
Attached Files
File Type: zip FolderImages v3.zip (138.1 KB, 4 views)
File Type: zip Display large image of Thumbnail in a form.zip (665.3 KB, 4 views)
__________________
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.

Last edited by isladogs; 09-23-2018 at 06:08 AM.
isladogs is offline   Reply With Quote
Old 09-23-2018, 09:48 AM   #10
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 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) ?
BeeJayEff is offline   Reply With Quote
Old 09-23-2018, 10:18 AM   #11
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,928
Thanks: 92
Thanked 1,707 Times in 1,584 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
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.
__________________
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, 01:51 AM   #12
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 ?

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 !
BeeJayEff is offline   Reply With Quote
Old 09-24-2018, 02:30 AM   #13
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,928
Thanks: 92
Thanked 1,707 Times in 1,584 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Talking 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
__________________
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
The Following User Says Thank You to isladogs For This Useful Post:
BeeJayEff (09-24-2018)
Old 09-24-2018, 05:15 AM   #14
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 ?

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.
BeeJayEff is offline   Reply With Quote
Old 09-24-2018, 05:17 AM   #15
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,847
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 ?

look at this link it will convert raw image to any format:

https://www.sno.phy.queensu.ca/~phil/exiftool/
__________________
"Never stop learning, because life never stops teaching"
arnelgp 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 11:33 PM.


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

Sponsored Links

How to advertise

Media Kit


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