Connection to the OLE Server was lost

[Dan S.]

We are running an Access 97 on XP Professional. Office
2002 Standard is also installed (no Access 2002).

In an Access 97 database, an OLE Object field for
inserting photos or files on one of the forms does not
work properly with photos anymore, since the transition
to XP from Windows 2K and NT 4 where it worked fine.

We can still insert Office 2002 files such as Word and
Excel, however when we attempt to insert a .jpg or .bmp
image the following error results:

"The connection to the OLE server was lost, or the OLE
server encountered an error while you were using it.
Restart the OLE server and then try the Operation again."

We use McAfee Virus scan, and I have tried excluding
*.mdb files such as suggested here for a quasi similar
problem with Access 2000 running Norton Antivirus, but no
change in error. I have searched many forums here and
the MS Knowledge Base for this problem to no avail.

Any suggestions would be much appreciated.

Dan S.

 

[Exponent]

This is most commonly caused by not having MS Photo Editor (or other suitable OLE server application) installed
on the system and registered for the relevant file types.

But note that there can be significant drawbacks with this approach (quite apart from your users being
stuck with having this app associated with the file-types), usually the most serious of which is an overhead
of between 10 and 100 *times* the filesize for jpeg images (even when linking). To store compressed images
inside the database it is usually better to store only the raw binary data, or when working with external
image files just store the path and load the file into an Image Control.

 

[ahmedamin]

restore the system to get red of any update and other installation that could conflict with access
It did work for me