Creating an Object Field



After you've opened the table you want to change in Design view, click in the first empty row or insert a new row (shown here).


Type a name for the field (in this example, Picture) and press Tab.


Click the down arrow that appears in the Data Type column and click the OLE Object option in the list that appears.


Click the Save button to save the table design.


In addition to storing text, numbers, and links, you can also store objects, such as pictures, worksheets, sounds, and so on, in your database. For example, you might want to include a picture of each product in a product database table. You aren't limited to pictures, however; you can include a worksheet, Word document, sounds, and other file types.


Linking OLE Objects

When you insert an object, it is embedded in the database file, separate from the original file. You can, however, set up the OLE object so that the database object is linked to the original file. To do so, click the Link check box when inserting the file. When the files are linked, if you update the original file, the file in the database table is updated as well. Consult online help for more information on linking data from other programs to an Access table.