I am trying to code a button in Access that will allow me to automatically transfer pictures and video from a digital camera to my hard drive.  After transferring, I want to automatically delete the pictures from the camera.  I have been unable to find any VBA code using WPD or the PortableDeviceAPI 1.0 Type Library.  Since portable devices do not resolve to drive letter, CopyFile or CopyFolder are not useable.  The system I am implementing this on contains both Win 7 Pro and XP Pro SP3 clients. 

Can someone please assist me with getting this set up or point me to some examples?  The only thing I have found is C++ which does not work in Access.  Thanks!

Jeff