Microsoft KB Archive/207692

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

Article ID: 207692

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q207692



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

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
When you set the RowSourceType property of a bound or unbound object frame, you may receive a message similar to 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 that you're connected to the network server where the OLE server application is located.
 * Quit 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:

An error occurred while sending data to the OLE server (the application used to create the object).
 * You may have tried to send too much data. If you're creating a chart and the chart is based on a query, modify the query so that it selects less data. If the chart is based on a table, consider basing it on a query instead so that you can limit the data.
 * You may be using an OLE server that doesn't accept the Clipboard format.
 * You may not be able to start the OLE server because it's not properly registered. Reinstall it to register it.
 * Your computer may be low on memory. Close windows to free up memory, or restart Microsoft Windows.

NOTE: If you have given the database an Application Title, that title replaces "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
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.


 * 1) Start Microsoft Access and open the sample database Northwind.mdb or the sample project NorthwindCS.adp.
 * 2) In the Database window, click Report under Objects, and then click New to create a new, blank report in Design view not based on any table or query. Click OK.
 * 3) On the Insert menu, click Object.
 * 4) In the Insert Object dialog box, click Create from File.
 * 5) Click Browse.
 * 6) In the Browse dialog box, select Bubble.bmp in the Windows folder (directory), and then click OK.
 * 7) In the Insert Object dialog box, click OK.
 * 8) On the View menu, click Properties to open the Bubble.bmp object frame's property sheet, if it is not already open.
 * 9) In the property sheet for the object frame, select Table/Query from the Row Source Type box.
 * 10) On the File menu, click Print Preview.

Note that you see the following message:

An error occurred while sending data to the OLE server (the application used to create the object).
 * You may have tried to send too much data. If you're creating a chart and the chart is based on a query, modify the query so that it selects less data. If the chart is based on a table, consider basing it on a query instead so that you can limit the data.
 * You may be using an OLE server that doesn't accept the Clipboard format.
 * You may not be able to start the OLE server because it's not properly registered. Reinstall it to register it.
 * Your computer may be low on memory. Close windows to free up memory, or restart Microsoft Windows.

NOTE: This message varies depending on the type of object that you have inserted.

