OLE Communication Problem

G

Guest

Hi,

I am trying to insert some pictures into a table in access, and everytime I
try and pull one in, I get this message, and can't figure out what the deal
is:
"A problem occured while microsoft access was communicating with the OLE
Server or ActiveX Control. Close the OLE Server and restart it outside of
Microsft Access. Then try the original operation again in Microsoft."

Any suggestions? Thanks!
 
G

Guest

Hi Liz,

While this KB article talks about a problem with embedding or linking a Word
document, I believe the same idea applies to other OLE servers as well. This
KB article includes reinstalling the OLE server as a possible resolution:

http://support.microsoft.com/?id=295824

If your system does not have the Office Graphic Filters installed, you can
download GDI+DLL.zip from Stephen Leban's web site:
http://www.lebans.com/loadjpeggif.htm

Please note that the link on this page that points to the download from
Microsoft appears to be no longer valid.

You can also try re-registering the OLE server. So, find the executable file
for whatever application on your PC is normally used to open the images. Then
try reregistering it as follows:

Verify that the Office application that you want to automate is installed on
the local computer. Make sure that you can run the application. To do this,
click Start, click Run, and then try to run the application. If you cannot
run the application manually, the application will not work through
automation.
• Re-register the application as follows: 1. Click Start, and then click Run.
2. In the Run dialog box, type the path of the server, and then append
/RegServer to the end of the line.
3. Click OK.

The application runs silently. The application is re-registered as a COM
server.
If the problem occurs because a registry key is missing, these steps
typically correct the problem. Ref.: http://support.microsoft.com/?id=828550


You might want to use this method instead, to avoid the bloat problems
associated with using OLE Embedding:

How to display images from a folder in a form, a report, or a data access
page
http://support.microsoft.com/?id=285820


Good Luck,
Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hi,

I am trying to insert some pictures into a table in access, and everytime I
try and pull one in, I get this message, and can't figure out what the deal
is:
"A problem occured while microsoft access was communicating with the OLE
Server or ActiveX Control. Close the OLE Server and restart it outside of
Microsft Access. Then try the original operation again in Microsoft."

Any suggestions? Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top