You're not too clear about your requirement here. Presumably you want to take pictures periodically, and store them for subsequent display via a Microsoft Access application. If so, then this forum may be appropriate.
Check out the camera documentation re automatically taking the pictures, and how they are saved onto disk. Its my guess that they will be saved to a single folder, with a filename based on a function of the date and the time.
When you confirm that the above is what happens, and is in line with your requirements, then we'll take it to the next step ... ie. retrieving the images between two times, via an Access form.
Cheers,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)