ACC2000: Unable to Paste OLE or Image Objects from Office Clipboard

After you copy an OLE Object field or Image field object to the Clipboard, you are unable to paste the object into another OLE Object field by using the Clipboard toolbar.

To work around this problem, use one of the following methods:

• Select the OLE Object field, and then click Copy on the Edit menu. Select the next OLE Object field, and then click Paste on the Edit menu.
  
  -or-
• Right-click the OLE Object field, and then click Copy. Right-click the next OLE Object field, and then click Paste.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

When you copy multiple items in Microsoft Office or in Access 2000, usually the Clipboard toolbar is activated. The Clipboard toolbar can list up to 12 items that have been copied to the Clipboard. When you click any one of the 12 items, the item is pasted into the document or the field that has the focus at that time. However, if an OLE Object field has the focus, and if the item that you click on the Clipboard toolbar is an OLE object, that item is not pasted into the OLE Object field.

Other field types, such as Text, Memo, Number, Date/Time, Currency, Yes/No, and Hyperlink fields do not exhibit this behavior. The AutoNumber field is excluded from this list for obvious reasons. AutoNumbers are designed to be self-generating, and will not allow values to be inserted. Timestamp fields in an Access project are also excluded. The OLE Object type, however, should not be excluded. OLE Object types should allow you to paste from the Clipboard toolbar.

In the following steps, the information in parentheses applies if you are working with an Access project.

Steps to Reproduce the Behavior

1. Start Microsoft Access 2000, and then create a new database or a new project.
2. Create a new table with two fields: an AutoNumber (Identity) field, and an OLE Object field (Image).
3. Insert two records into the table and store .bmp files into the OLE Object (Image) fields.
4. Select the first record, and then press CTRL+C to copy the record to the Clipboard (not the OLE object itself).
5. Select the second record, and then press CTRL+C. The Clipboard toolbar should be activated. If the Clipboard toolbar does not appear, click View, and then click Clipboard.
6. Move to a new record in the table, and then click the first item on the Clipboard toolbar to paste the data. Note that the data is pasted successfully.
7. Right-click the OLE Object (Image) field in the first record, and then click Copy. Note that a third item appears on the Clipboard toolbar, with an icon that is different from the first two.
8. In a new or an existing record, click in the OLE Object (Image) field.
9. Click the third item, the OLE object, on the Clipboard toolbar. Note that this item is not pasted into the OLE Object (Image) field.