Here is a sample video of photo management software that we have created using Access for a number of mining companies. This video shows the software in action and doesn't include any vba code. In this particular sample, the photo is moved to a sub folder and name that corresponds with the primary keys of the records that the photo relates to. The photo is not stored in the database. The video goes for 5 minutes and is narrated by Garry Robinson.