Page 1 of 2 12 LastLast
Results 1 to 15 of 17

Thread: OLE Server

  1. #1
    COURTADM
    Guest

    OLE Server

    I have a Access Database in which I have a few Access Reports that have embedded Word Documents in them. When I go into design mode in reports I get the following error " Database cannot communicate with OLE Server. The OLE Server may not be registered. To register the OLE Server, reinstall it. So how do I register an OLE Server. I have attempted to re-install Office 97 with no luck to clear the error. Appreciate your assistance in this matter!

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OLE Server

    I would have thought re-installing Word (via reinstalling Office 97) would have re-registered Word (which I believe is the OLE Server in question). Since that did not work as per your post, I too shall await a more learned response from a more learned poster.

    I've had this same error crop up while trying to embed a Word 2000 document in Publisher 2000.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OLE Server

    Reinstalling IS the official resolution:

    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q212/6/47.ASP>http://support.microsoft.com/support/kb/ar...s/Q212/6/47.ASP</A>
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  4. #4
    Mark Wilton
    Guest

    Re: OLE Server

    I am experiencing this same problem, but the Q-article to which your message points does not seem to apply. What is the IS that you suggest needs to be reinstalled?

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OLE Server

    Sorry, I'm just as lost as you are on this one. That Q article seems to indicate or flattly states the reinstalling the app solves the problem. In an OLE context both the client and the server can be both the client and the server, so reinstall both apps??

    Beats me. You could try reinstalling both the calling App and the called app.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  6. #6
    Mark Wilton
    Guest

    Re: OLE Server

    I completely re-installed Office 97 and it did not help.

  7. #7
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OLE Server

    And by that you mean both the client and server, say Excel and Word, got reinstalled?

    Like I said, "beats me."
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: OLE Server

    Do you have more than one version of Office/Word/Access on your machine? That could confuse Access, especially if the other version was the last one loaded.
    Charlotte

  9. #9
    Mark Wilton
    Guest

    Re: OLE Server

    No, I only have Office 97 installed. This problem only started a while ago. Everything was working at one point. I am not sure, but I may have installed VB 6 about the same time as this problem started to occur.

  10. #10
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: OLE Server

    That may very well be the cause of the problem. VB6 installs a bunch of dlls, some of which have the same name as the older ones but don't behave the same way. Reinstalling Office won't overwrite later versions of the dlls. Check your references in Access and see if you have any that are MISSING.
    Charlotte

  11. #11
    New Lounger
    Join Date
    Feb 2001
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: OLE Server

    I am getting the same problem trying to put a Word 2000 doc into an Access 2000 form. The same message appears on all 4 of my office computers. In another company where I am currently working, there is no problem so, acting on a complete hunch, I have replaced the contents of C:Program FilesCommon FilesSystemOle DB with the files from a machine where OLE works. Hey presto! My OLE now works fine <img src=/S/cool.gif border=0 alt=cool width=15 height=15>
    Woops! In the time it took me to type the above, OLE has gone belly up again <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23>

  12. #12
    Mark Wilton
    Guest

    Re: OLE Server

    Charlotte,

    I am confused by your suggestion that I check my references. What exactly do you mean by this? Also, do you know of where I might find a list of DLLs and their uses, so I can determine which one handles the OLE.

    Thanks,

    Mark.

  13. #13
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: OLE Server

    Go into the VB Editor (Alt+F11, or whatever method you commonly use). Select the Tools menu and click References. You'll see a list of available libraries. Those that have check marks next to them have been added to your database. If any of the say MISSING, it means that the computer can't find that filename in the location specified.

    There is an OLE automation library, but that may not be the problem. That library is at C:WINNTSystem32stdole2.tlb on my machine, but that may vary depending on operating system. However, any time you try to automate one application from another (i.e., open Word from Access and do a mail merge), the remote application is acting as an OLE server, so the automation library may not be the one causing you problems.
    Charlotte

  14. #14
    Mark Wilton
    Guest

    Re: OLE Server

    Thank you for this assistance, Charlotte. Unfortunately, no go. None of the references say "Missing" (I checked in Access, Word and VB) and the STDOLE2.TLB file is in place.

    Is there any registry entries that I should be looking at?

  15. #15
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: OLE Server

    Not that I know of. What operating system are you using?
    Charlotte

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •