Microsoft KB Archive/173933

= ACC: OLE Object Error When Setting the RowSourceType Property =

Article ID: 173933

Article Last Modified on 1/20/2007

-

APPLIES TO


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

-



This article was previously published under Q173933



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



SYMPTOMS
When you set the RowSourceType property of a bound or unbound object frame, you may receive one of the following error messages, depending on the type of OLE object that is contained in the frame:

For Microsoft Excel Charts:

The operation on the OLE object failed.

The OLE server may not be registered.

To register the OLE Server, reinstall it.

For Microsoft Excel Spreadsheets:

A problem occurred while Microsoft Access was communicating with the OLE server.

Try one or more of the following:


 * Make sure you're connected to the network server where the OLE server application is located.


 * Close the OLE server and restart it outside of Microsoft Access. Then try the original operation again from within Microsoft Access.


 * Reinstall the OLE server to ensure that it's registered."

For Bitmap Image, WordPad, Media Clip, Microsoft Equation Editor, Microsoft Map:

Microsoft Access can't read the OLE object because communication was interrupted.

If the OLE server application is located on a network server, make sure your computer is connected to it.

NOTE: If you have given the database an Application Title, that title will replace "Microsoft Access" in the messages.



CAUSE
The RowSourceType property is not available for all OLE object types, but because it is available for some, the property is visible on the property sheet for all OLE objects.



RESOLUTION
Remove the setting for the RowSourceType property for the OLE Objects mentioned in the "Symptoms" section.



Steps to Reproduce Behavior
 Open the sample database Northwind.mdb (or NWIND.MDB in Microsoft Access 2.0) and create a new, blank report in Design view. In Microsoft Access 95 and 97, on the Insert menu, click Object.

In Microsoft Access 2.0, on the Edit menu, click Insert Object. In the Insert Object dialog box, click Create From File. Click Browse. In the Browse dialog box, locate the Bubble.bmp file in the Windows folder (directory) and click Open.</li> In the Insert Object dialog box, click OK.</li> In the report's Design view, right-click on the Object Frame. On the shortcut menu, click Properties.</li> In the Property sheet for the object frame, select Table/Query from the Row Source Type box.</li>  On the File menu, click Print Preview. Note that you see the following message:

<pre class="fixed_text">     Microsoft Access can't read the OLE object because communication was interrupted.

If the OLE server application is located on a network server, make sure your computer is connected to it. </li></ol>

NOTE: This message will vary depending on the type of object you have inserted.

<div class="references_section">