starting OLE server

[Guest]

I have an access data base in which I have a form with an OLE object (a
photograph of my clients). This has developed a fault in that when I try and
drag a photograph to the form I get a message "A problem occured while
datatbase was communicating with the OLE server or active X control. Close
the OLE server and restart it outside of the database." I have tried
everything including uninstalling and reinstalling the office suite, but the
problem remains. Also outlook will not use word for composing emails. Its as
if the office programmes can no longer communicate with each other.

 

[David Lloyd]

The following KB article deals with a error message similar to what you are
seeing.

http://support.microsoft.com/default.aspx?scid=kb;en-us;295824

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have an access data base in which I have a form with an OLE object (a
photograph of my clients). This has developed a fault in that when I try and
drag a photograph to the form I get a message "A problem occured while
datatbase was communicating with the OLE server or active X control. Close
the OLE server and restart it outside of the database." I have tried
everything including uninstalling and reinstalling the office suite, but the
problem remains. Also outlook will not use word for composing emails. Its as
if the office programmes can no longer communicate with each other.

 

[Guest]

Thank you for your response but this article seems to relate only to problems
with norton anti virus. I do not have any norton programmes installed on my
computer.

 

[bob]

Check which application you were using as the 'OLE Server' by opening the table and examining the content
of the field that contains your existing images. You should see something like 'MS Photo Editor Object',
'MS Paint Bitmap' etc.

Make sure that this application is installed and registered for the file-types that you are trying to store.

Note that this approach has several drawbacks: as well as common configuration issues like this, jpeg images
typically take up between 20 and 200 *times* the space in the database as the original jpeg file size.
The common 'OLE Server' application for images was dropped in Office 2003. You cannot extract the original
jpeg image, and the data is stored in a private format, so cannot be used with other applications, eg a
web or VB front-end.