Attaching Images in Bulk to a Form/Table with Access 2007

[efandango]

I want to bulk attach a large numbe rof image files from a folder to a form
using Access 2007


I have a very long list of Images in a single folder that I want to attach to
seperate fields in a table/form. I am Using Access 2007 and thought that I
would somehow be able to 'automate' the new 'file attachment' feature, but
was surprised and dissapointed to discover that I would have to manually
attach each single file onto 320 forms (x2 images per form) 640 times!, Is
there a way around this problem without resorting to actually pasting/binding
the images into a potentially huge mdb file.

Each form record contains two images, where I want 2 images per form. The
Image pairs correspond to the record number. For example.

Record 005:
W:\Foldername\Micromap Run 005 A.bmp =(5th record)
W:\Foldername\Micromap Run 005 B.bmp =(5th record)

The table format is:

Run_No
ImageRecord_A
ImageRecord_B


a fuller example of the folder/file naming convention is as follows:

W:\Foldername\Micromap Run 001 A.bmp =(1st record)
W:\Foldername\Micromap Run 001 B.bmp =(1st record)
W:\Foldername\Micromap Run 002 A.bmp =(2nd record)
W:\Foldername\Micromap Run 002 B.bmp =(2nd record)
W:\Foldername\Micromap Run 003 A.bmp =(3rd record)
W:\Foldername\Micromap Run 003 B.bmp =(3rd record)

and so on...




Is there a way of doing this automatically?

The total list of records is 320 (x2 = 640 images)