ACC: OLE Objects Do Not Appear in Output File

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q169277

Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

If you output a report from Microsoft Access to another file format, such as .rtf, .txt, .xls, or .html, an OLE object that has been inserted into the report does not appear.

Back to the top

CAUSE

Although some output file formats, such as .rtf or .xls, do support embedded or linked OLE objects, Microsoft Access does not support outputting an OLE object to another file format.

Back to the top

RESOLUTION

If the OLE object has been saved separately, you can first output the report and then insert the OLE object in the resulting file.

Back to the top

MORE INFORMATION

Steps To Reproduce Behavior

Open the sample database Northwind.mdb.
Click the Reports tab, and then click the New button.
In the New Report dialog box, click AutoReport: Tabular, in the "Choose the table or query where the object's data comes from" box, choose the Shippers table, and then click OK. The report opens in Preview mode.
On the View menu, click Design View. Select the detail section of the report.
On the Insert menu, click Object. In the Insert Object dialog box, select Microsoft Clip Gallery, and then click OK. Choose a picture and click the Insert button.
On the View menu, click Print Preview. The picture appears in the detail section of the report.
On the Tools menu, point to OfficeLinks, and then click Publish It With MS Word. If the Convert File dialog box appears, select Rich Text Format (RTF), and click OK. The report opens in Microsoft Word, but the OLE object does not appear.

Back to the top

REFERENCES

For more information about outputting data, search the Help Index for "OutputTo action," or ask the Microsoft Access 97 Office Assistant.

Back to the top

APPLIES TO

Microsoft Access 2.0 Standard Edition
Microsoft Access 95 Standard Edition
Microsoft Access 97 Standard Edition

Back to the top

kbinterop kbprb KB169277

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top