Microsoft Access 2007 has finally resolved the issues regarding image linking through the data type Attachment. The new feature is capable of adding one or more pieces of data or images to the records in your database. Several files can now be stored in a single field. These new data type saves the file in their native formats freeing you from installing additional software to view the attachments.

The older versions only support data type as Object Linking and Embedding (OLE) to store images and documents to the table but is quite not advisable as it may enlarge your database file size.

With attachments data type in MS Access 2007 you can now be able to link images  from different locations or folders to the records of your table.

How to create a table with attachment data type?
  • create a new MS Access 2007 file.
  • create a new table with the following fields and field types:
    • id - Autonumber
    • product - Text
    • image - Attachment
  • save your table as Products
  • create Multiple Items form and save it as Products
  • double-click the form and start entering data
    • skip the ID field and type Toy Story 3 in the Title field
    • double-click the Image field and add the image from your folder
  • continue adding more records
This how would your work look like after.


Now you can be able to create inventory of files with outrageous images as attachments. Click the attachment field anytime if you want to change the image.

Related article: