Create a field to store OLE objects (pictures, Word documents, and so on)

Create a field to store OLE objects (pictures, Word documents, and so on)

  1. Open a table in Design view.

  2. To insert the field within the table, click in the row below where you want to add the field, and then click Insert Rows on the toolbar.

    To add the field to the end of the table, click in the first blank row.

  3. In the Field Name column, type the name for the field, following Microsoft Access object-naming rules.

  4. In the Data Type column, click the arrow and select OLE Object.

Note   OLE Object fields are used to store data such as Microsoft Word or Microsoft Excel documents, pictures, sound, and other types of binary data created in other programs. OLE objects can be linked to or embedded in a field in a Microsoft Access table. You must use a control in a form or report to display the OLE object. To find out more about editing and displaying objects stored in OLE Object fields, click .