ACC2000: OLE Object Error When Setting the RowSourceType Property (207692)


The information in this article applies to:

  • Microsoft Access 2000
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.

MORE INFORMATION

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.

REFERENCES

For additional information about OLE objects, click the article number below to view the article in the Microsoft Knowledge Base:

199066 ACC2000: How to Retrieve the Path for Linked OLE Objects

Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kberrmsg kbprb KB207692
©2004 Microsoft Corporation. All rights reserved.