Adding an Image into an Access 2007 Table
Now that you have created a table, named a new field with the title “Product Images," and specified that the field’s Data Type is OLE Object, you can now place your image into the table.
Using the Office 2007 Ribbon, go back to Datasheet View. Right click on any empty cell in the newly created “Product Images" field and click on “Insert Object" (see Figure 4). Note that this option would not have been available if the “Product Images" field still had a “Text" Data Type.
When you click on “Insert Object," a new mini window opens asking if you want to create a new object or create a new object from a file. Before you continue, take a look at the list to the right when the “Create New" radio button is selected. You will see different object and document types here depending on the programs you have installed on your computer (or network). This list gives you an idea of just how versatile OLE is and the number of objects and documents that can be added to an Access 2007 Table.
To add an image you have already created, click the “Create from File" radio button and locate the image with the “Browse" button. When you find the image you want to add to the table, click “OK" and the cell will change to the word “Package" to indicate that an OLE object is present in that cell. Notice that the image itself is not shown in the cell. However, you have indeed added the image to the table. From here, you can use the image in any of your database applications or queries.