uploading multiple photos into access

[dj rivum]

Hi there
im trying to build a database that stores a large number of photos and would like some suggestions on how i can upload multiple photos (20+) at one time without uploading each one individualy, preferably through a form.

To outline the problem, each member of the team has a camera that they take to jobs, when they return i want them to be able to open a new form, enter the job number (the primary key) onto the form and then somehow drag and drop the pictures from the camera onto the form to upload them.

Is this possible through Access? is this the best way of uploading multiple photos easily? and how do i build this?

Thanks in advance
MJ

 

[VicRauch]

Did you want to store the photos in Access, or just a link to where the photo can be found?

 

[dj rivum]

I was thinking idealy i want the photos in the DB but as this will cause the DB to bloat a link may be more efficent. TBH what ever is easiest

thanks