Results 1 to 12 of 12
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Button gives OLE Server Error (2000)

    A couple of times recently I have come up gainst the following error when testing a button on a new form:

    A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX control

    I am not using, to my knowledge, any OLE servers or any ActiveX controls beyond the buttons themselves. I click to acknowledge the message then nothing happens. The code behind the button does not run and I am not given any more information. I then cannot use any of the buttons on the form as they all produce the same error. I've tried the usual fixes; compacting, importing objects into a new database, but without success. I've tried changing references then recompiling, rewriting the button code and deleting then recreating all the buttons on the form, again without success. It seems that once a form hits this problem the whole form becomes unusable. The only way round it that I have found is to delete the form and start again.

    The buttons on the forms in question were all created by the button creation wizard, which has worked well many times before and since. So far the problem has only happened in the early stages of creating a form, so deleting it and starting again hasn't been too much trouble. However, I am now worried that I will get the problem towards the end of a big form when starting again will be an unpleasant prospect.

    It

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Button gives OLE Server Error (2000)

    > PS Is there a search function for the Access Forum?

    A search function is available throughout the Lounge. If you click the 'Search' button in the 'menu bar' near the top of the Window, you can specify a text to search for and several options. By default, you will search within the current forum, but you can change that too.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Button gives OLE Server Error (2000)

    It's unusual that this error occurs for a built-in command button. For other situations, Microsoft points at Norton Anti Virus as the culprit, see <!mskb=295824>Microsoft Knowledge Base Article 295824<!/mskb>.

    I found some suggestions that changing the system locale in the Regional Settings control panel might help. No idea how or why, but you might give it a try.

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

    Re: Button gives OLE Server Error (2000)

    I've seen it happen on occasion, and it always signals to me that I need to compile the code. For some reason, Accessd 2000 and above sometimes seem to lose track of all the bits of a particular form or report (or both, or several), and compiling the code will turn up one or more instances of the IDE not recognizing a reference to a control or a field, even though there is nothing actually wrong with the code. In that case, making some kind of nominal change to the design, like reselecting the data source, and then saving the object again seems to take care of it. Once in awhile something can go more seriously wrong and you'll need to select Detect and Repair from the Help menu and let it fix your Access/Office installation.
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Button gives OLE Server Error (2000)

    I tried the small change then recompile trick, but it did not work.
    However, what is Detect and Repair? I had never noticed it before and there doesn't seem to be anything about it in the help system. Are there any downsides to using it?

    Thanks

    Ian

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Button gives OLE Server Error (2000)

    Here is the help text for Detect and Repair in Access 2002:

    <img src=/w3timages/blueline.gif width=33% height=2>

    <big>Automatically repair Office programs</big>

    Caution Choosing this option will discard many of your customized settings and restore default settings. For instance, the following will be set back to the state they appeared when you first installed Office:
    <UL><LI>The Assistant character selection
    <LI>Most-recently-used entries on the File menu will be removed
    <LI>The size of the application window for all applications
    <LI>Menu and toolbar position and any customizations
    <LI>Customizations and additions to Office Shortcut Bar
    <LI>The security level for each application
    <LI>View settings within the application, such as the Calendar view in Outlook [/list]Your User Name and Initials will also need to re-entered when you restart your Office applications.
    1. <LI>On the Help menu, click Detect and Repair.
      To restore the program shortcuts to the Windows Start menu, make sure the Restore my shortcuts while repairing check box is selected.
      <LI>Click Start.
    Notes
    <UL><LI>This feature is not available for Office applications earlier than Office 2000.
    <LI>This procedure detects and repairs problems such as missing files and registry settings associated with all installed Microsoft Office programs. It will not repair personal files, such as spreadsheets or documents.
    <LI>If the Detect and Repair command does not fix the problem, you might need to reinstall Microsoft Office.[/list]<img src=/w3timages/blueline.gif width=33% height=2>

    It is up to you to decide if you want to use it.

  7. #7
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Button gives OLE Server Error (2000)

    Hans,

    I realize that this is a six-month old post, but I'm curious as to whether or not any new developments or solutions have popped up since. I've run into exactly the same problem. I did try your suggested solution, but it did nothing for me. Hopefully,
    Cheers,
    Andy

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Button gives OLE Server Error (2000)

    What were the circumstances in which the error occurred?

  9. #9
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Button gives OLE Server Error (2000)

    Hans,

    Thanks for replying. I'm off to ex-wife's birthday party, so I'll have to get back to you tomorrow with all the gruesome details. About my problem, not the party,
    Cheers,
    Andy

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Button gives OLE Server Error (2000)

    Er, yes. Should I wish you a good time or strength?

  11. #11
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Button gives OLE Server Error (2000)

    Good Sunshiny Morning Hans!

    Fear not, a good time was had by one and all. Now back to the original problem. A suggestion that I've heard reiterated a number of times with respect to Access problems is, when all else fails, create a new empty database, import everything from the old one and try it again.

    And it worked! No idea why, but who cares. So, to all and sundry, if at first you don't succeed, try the new database/import route. It doesn't cost much in time and you might get lucky like I did.

    Thanks again,
    Cheers,
    Andy

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Button gives OLE Server Error (2000)

    Yes, importing as much as possible from a problem database into a new blank database will solve a lot of problems, so it's a good general purpose tip.

Posting Permissions

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