Access 2007 Methods
Access 2007 introduces a data type called "attachment". The complete list of data types available to define a field in a table in Access 2007 now include text, memo, numbers, date/time, etc. The hyperlink data type allows for storage of hyperlinks and the field can be a solution for the indirect method discussed previously. The OLE data type is still available, and you can use it the old manner. The new data type attachment however, is the right type for storing images. It can store documents, including all kinds of Office files and binary objects. A field created with this data type can have up to 2 GB storage allocated. Individual files cannot be more than 256 MB though. You can have more than one file attached to a record.
Whenever you need a field that can hold images and other attachments, remember to create a field for the same, name it and set the data type as "attachment". To add attachments to a table, you do not need a data entry form. Instead open the table in the datasheet view. Double click the attachments field and the attachments dialog box appears. The dialog box lets you look through your directory for the file to be attached. Viewing attachments also does not need the use of a form. Simply open the table, go to the right record, and double click the specific icon of the attachment (as there can be multiple attachments in a attachment field). The document will open in the associated program. For example, a .DOC file will open in Word.
Fig 1: Attachment Dialog Box
Read this article for more details on Access tables in general.