Attaching photos to Access Databases

Hi Rachel, Thank you for the post, welcome to the forum, in answer to your question yes, For forms and reports, Access will happily accept Windows bitmap (.bmp) files as OLE objects and you should not need a separate graphics filter installed to insert Enhanced Metafile (.emf), and (.rle, .dib) files, or Windows Metafile (.wmf), and icon (.ico) graphics.
However, you will need a graphics filter installed to insert all other graphics file formats, if you have to use .jpg files you may have to use a filter to accomplish this. You should ensure that your photographs have been correctly identified with unique names/numbers etc. it would also help if they were all (or copies of them) were in the same folder.
Then follow these steps:
In your table in design view create an OLE object field.
Save the table, in Table view select the blank field in the record of your choice and from the Insert menu select Object, from the dialog box that opens, select Create from file and click Link and then Browse, navigate to your folder and select the correct photo for that record. Create a Form based on the table or query which has the OLE field in it and you should then be able to view your photo on the correct record. If you are not using the .bmp file format, it is possible that you may see the text "Package" in the field, if this is the case your picture will not display in the form or report. I hope that has helped, if so please click the Resolved link, best regards Pete.