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:
For Microsoft Excel Spreadsheets:
For Bitmap Image, WordPad, Media Clip, Microsoft Equation Editor, Microsoft Map:
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.
MORE INFORMATION
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.
- In the Insert Object dialog box, click OK.
- In the report's Design view, right-click on the Object Frame. On the shortcut menu, click Properties.
- In the Property sheet for the object frame, select Table/Query from the Row Source Type box.
On the File menu, click Print Preview. Note that you see the following message:
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: This message will vary depending on the type of object you have inserted.
REFERENCES
For more information about OLE objects, please see the following articles in the Microsoft Knowledge Base:
112749 ACC2: List of OLE 2.0 Features Supported in MS Access v. 2.0
170531 ACC: How to Retrieve the Path for Linked OLE Objects (7.0/97)
Additional query words: Active X can t
Keywords: kberrmsg kbprb KB173933