Including Objects from Other Applications: Linking Versus Embedding
Microsoft Access is an ActiveX client application, meaning that it can contain objects from other applications. Access 97, and all subsequent versions of Access, are also ActiveX server applications. Using Access as an ActiveX server is covered in Chapter 22, "Automation: Communicating with Other Applications." Access's ability to control other applications with programming code is also covered in Chapter 22. In the following sections, you learn how to link to and embed objects in your Access forms.
Bound OLE Objects
Bound OLE objects are tied to the data in an OLE field within a table in your database. An example is the Picture field that's part of the Categories table in the Northwind database. The field type of the Categories table that supports multimedia data is of the OLE object field type. This means that each record in the table can contain a unique OLE object. The Categories form contains a bound OLE control, whose control source is the Picture field from the Categories table.If you double-click the picture associated with a category, you can edit the OLE object in-place. The picture associated with the category is actually embedded in the Categories table. This means that the data associated with the OLE object is stored as part of the Access database (MDB) file, within the Categories table. Embedded objects, if they support the OLE 2.0 standard, can be modified in-place. This Microsoft feature is called In-Place activation .To insert a new object, take the following steps:
Figure 9.18. The Insert Object dialog box as it appears when you select Create from File.

Access returns you to the record that you were working with, and you can continue working with that record or move to another record.If you double-click a linked object, you launch its source application; you don't get In-Place activation (see Figure 9.19).
Figure 9.19. Editing a linked object.

Unbound OLE Objects
Unbound OLE objects aren't stored in your database. Instead, they are part of the form they were created in. Like bound OLE objects, unbound OLE objects can be linked or embedded. You create an unbound OLE object by adding an unbound object frame to the form.