'Read' an Image from a Digital Camera

[MinnesotaBill]

Let's try this again. I have a need to be able to copy the image file
xxx.jpg from a Digital Camera and writ it to a folder on the hard drive
giving it a new name, say "Picture1.jpg". This needs to be accomplished
using a button on an Access form.

Does any one have any thoughts about how to do this in VBA for Access 2000
or Access 2003?

Thanks in advance,
Bill

 

[Brendan Reynolds]

As far as I can tell, Windows appears to see a USB-attached digital camera
as just another disk drive. If so, you should be able to copy the images as
you would any other file, with the FileCopy command. Unfortunately, I'm not
in a position to test that right now. As it happens, I do have a digital
camera with me, but I don't have the USB cable to connect it to the PC. I'll
try to remember to test it when I get home this evening. I'm in the GMT time
zone, so my 'evening' may not be your 'evening'!

 

[Brendan Reynolds]

Turns out I didn't have to wait until this evening after all, I was able to
test using the cable from a USB wireless network adapter, and, yes, FileCopy
works ...

Public Sub CopyToCam()

'the e: drive is the digital camera
FileCopy "c:\usenet\test.jpg", "e:\dcim\100_fuji\test.jpg"

End Sub

Public Sub CopyFromCam()

FileCopy "e:\dcim\100_fuji\test.jpg", "c:\usenet\test.jpg"

End Sub