Copy query recordset photo files to a folder

  • Thread starter Thread starter Bradley C. Hammerstrom
  • Start date Start date
B

Bradley C. Hammerstrom

A2K,

My mdb stores Path and FileName to jpgs on a ProjectCD (linked, not
embeded). Users can then view photos and perform queries.

Now I need a way to copy the query result list of files (from various
folders on the CD) to a local folder selected by the user, for subsequent
printing. I do not wish to print directly from Access. (The db does not care
about the new Paths; the user does.)

What API can I use and how do I copy the query's recordset, if that's the
correct term?

Brad H.
 
Are you wanting to copy the actual jpg files to a folder, or store the file
paths in a text file?
 
William,

I want to copy the actual list of jpg files. I know this is a much different
task than copying the path and filename as text, but what I need is a way
for my database to first find a group of photos based on the user's search,
and then be able to copy them to a user-specified folder for later printing
or storage on CD, for example. By the way, the database has no need of
keeping track of the path and filename of the copied files.

I think what I need is a Windows API or such to accomplish what I need. Have
you heard of anything like this??

Brad H.
 
Back
Top