How do I go about importing 1000+ photos to an access database quickly?

[tuscaloser]

Hi, I'm at a bit of a standstill in a project I'm working on for a customer. Basically, I work for an ID Printer company and this order is for a school set of printed ID's.
Our software populates fields (name, grade,photo, etc) from an access database. I currently have a database of all the students that I'll be making IDs for. So, basically, I have a database of students (all identified by student number) and a folder full of their pictures (also identified by student ID number).
For instance, if an individual entry in the database was named S110566, the associated picture would be named S110566.jpg.
My question is this: Is there any way to make access pull the pictures from the picture folder into the database so that each picture is matched with its respective student ID number? I'm asking because there are roughly 2000 students, and linking every picture individually would be extremely time consuming.
I'd really appreciate any insight that one of you Access wizards could provide. thanks!

[Rabbit]

You should avoid storing image files in the database itself, it can quickly exceed the storage limitations of Access.

What you can do instead depends on your setup. Which you haven't told us so I can only guess.

If you have a field in the table that is linked to the picture, then you can just run an update query that dynamically builds the link based on the student id.

If you have it as a picture object on a form, use the On Current even to dynamically change which picture it is linked to based on the student id.