Hi Wendell, about the third option Storing images in Access Databases:

In Mark Andrews' reply,

Set RSAttachments = rs.Fields("Attachments").Value

to me sets RSAttachments to be the value of the Attachments field so

how can he use

RSAttachments.Fields("FileName").Value

since that asks for the value of the FileName field which RSAttachments isn't set to?