Hi Rick,

First of all, your videos have been extremely helpful and we really appreciate the aid you've provided in setting up our database.

We have a question. We are creating a database to store hundreds or even thousands of fairly large product photos, and we've created a database using your "image control" and "copy files to server" methods. We have photos in dozens of folders, and we created one new "shared" folder to hold the copies of the image files used in our database. However, our employer is concerned that making copies for all of these photos could take up too much space on the company server. They also do not want us to move/delete any of the pictures from the original folders.

Is there a possible work-around that you could think of for this issue? I understand that it is a complex situation and may not be easily solved, but we were wondering if you had any thoughts that could point us in the right direction. Thanks so much for your help and for your tutorials, which have also been extremely useful in creating our database.

Cheers!
Brian

---

Reply from Richard Rost:

Well, you don't necessarily have to copy all of the photos to a new folder. If they're already in a server folder that you can share and access via the database, just leave them where they are. Pick the file, save the path/filename in the database, and use the original.