Until recently, I have had no trouble inserting an OLE object into my Access database. (I am trying to insert a jpeg photo by reference; this database contains other OLE jpeg photos.) Suddenly, I am now unable to insert an OLE jpeg. I receive this message: “A problem occurred while Microsoft Access was communicating with the OLE server or Active X control. Close the OLE server and restart it outside of Microsoft Access. Then try the original operation again in Microsoft Access.”
I have searched your knowledge databases to little avail.
Sometimes I receive this error: “The OLE object isn’t registered. The object may be calling an application that isn’t installed.To register the application, reinstall it.”
I have reinstalled Access (I did not reinstall the entire MSOffice, however). The .jpg extension is associated with PaintShop Pro. I have uninstalled and reinstalled PaintShop to ensure that the extension is associated.
As a possible remedy, I selected Tools–>Active X controls–>Image. This clearly was not the answer, but I thought that since other .jpgs in the column were identified as “PaintShop Pro 7 Image” that it might be worth a shot.
I am taking the following steps when inserting an OLE object:
1. In Design view of my database Table, I created a field “Photo” and set the data type as OLE Object.
2.In View mode, I place my cursor in the desired field and select Insert–>Object.
3. In the Insert Object window, I select Creat from File, click Browse, and navigate to the .jpg file.
4. I click OK twice. (I have tried selecting Link and Display as Icon in various combinations with no change in the outcome.)]
5. I receive the error messages quoted above.
Can you shed some light on what might be happening here?
Thanks,
Carol
