I have an access database with a form for recording samples I take in the field, while in the field I take photos of the samples, I take anywhere from 2 to up-to 12 photos, it varies per sample. I would like to when I bring up the form have the pictures show up as well, I have over 90 samples and or data points with corresponding photos totaling over 350+ so embedding as on OLE is out of the question. I added all the links or folder and name paths to each record in the database an starting trying to use image controls to link the paths but often only one or two pics would show up, never any more than 3. So What I want to do is some how get the photos to show up in the form and then if I click on a photo it opens up the original photo.
thank you for the comments, i am going to take a look and the product that Joe suggested, and you all are right it might be too much for access to deal with but I wanted to see if there is an elegant solution, I will let you know what I find after I try the software out. I do believe in not reinventing the wheel.
Cheers Brian