Unable to embed an OLE object in an Access OLE field

[Santanio]

Hey Folks,

I have installed Windows Xp SP2 on my system. I had also installed Microsoft Office 2003 with Access 2003 on my pc. The problem is that whenever i try to embed an OLE object in an Access OLE field, it shows an "OLE Server Error" error message on the desktop screen. When i tried to configured the above issue by running Regsvr32.exe on my system, but couldn't resolve the above issue. Can any body help me out to resolve the above problem? Any kind of help would be appreciated.


Thanks.

[Eric B]

This problem may occur if you have Norton AntiVirus 2000, Norton AntiVirus 2001, Norton AntiVirus 2002, Norton AntiVirus 2003, or Norton AntiVirus 2004 installed on your computer. This problem may also occur if you have run Norton's LiveUpdate and have installed the Script Blocking update for Norton AntiVirus 2001, Norton AntiVirus 2002, Norton AntiVirus 2003, or Norton AntiVirus 2004.

[Glenny]

When you install Microsoft Office 2003, the Setup program removes all the standard components from Office XP (such as Photo Editor) that you previously had installed on your computer. As a result, Access 2003 cannot find the OLE Server that can display an image file (such as a .jpg file or a .gif file), and you cannot view the embedded graphic files or the linked graphic files.

Steps to reproduce the behavior

1. Start Access 2003.
2. Open the Northwind.mdb sample database.
3. In the Database window, click Tables under the Objects section.
4. In the right pane, double-click Create table in Design view.
5. Create a table that is named TestImage with the following details:

Table: TestImage
Field Name: FldImage
Data Type: OLE Object

6. Open the TestImage table in datasheet view.
7. In datasheet view, right-click the FldImage field, and then click Insert Object.
8. Select Create from File, and then click Browse.
9. Locate the .jpg image file. Select the .jpg image file, and then click OK.
10. Click OK.
11. On the File menu, click Close.
12. In the Database window, click Forms under the Objects section.
13. In the right pane, double-click Create form by using wizard.
14. In Form Wizard, select Table: TestImage from the Table/Queries drop-down list.
15. Click--> to move all fields from the Available Fields list to the Selected Fields list.
16. Click Finish.
17. If the form is not already open in form view, open the form in form view.

Notice that when you view the data in the table in datasheet view, the value of the OLE object is shown as a package image or as a bitmap image. Additionally, when you view the form that displays the OLE object in form view, the embedded image file does not appear. However, you can see the file icon for the image file that is embedded in the form.