Microsoft Access can't start the OLE Server

Discussion in 'Access Macros' started by Lotto, Nov 7, 2008.

  1. Lotto

    Lotto Guest

    When we searched this group we found the exact same problem from 1998
    but we are having the same problem now with Access 07 with the output
    to statement within a macro.


    Hi,
    Hope someone can help with this, I have a macro that uses the
    "OutputTo"
    action. The parameters are:

    Object type: Query
    Object name: qryUnionAllTables
    Output format: Excel sheet (.xls)
    Output file: c:\My Documents\qryUnionAllTables
    Auto Start: Yes


    I have one query in this format that functions exactly as
    expected.
    However, I wrote another query similar to this one, and when I run it,
    I
    get an error like:


    i Microsoft Access can't start the OLE Server


    You tried to use a form, report, or datasheet that contains an
    OLE object,


    but the OLE Server (the application used to create the object)
    may not be
    registered properly. Reinstall OLE Server to register it
    correctly.


    If I leave the Output file parameter blank, the macro runs, and the
    "Save
    As" dialog box opens. It shows the name of the query with an .xls
    extension
    as the default selection, and if I select it, it opens in excel
    exactly as
    expected. I have reinstalled Office 97 and ODE, still get the same
    results,
    the older query runs and newer queries function as described above. I
    can't
    tell from ODE and support online how to reinstall the OLE server. I
    have
    tried registering different file libraries for Excel, with no success
    either.
     
    Lotto, Nov 7, 2008
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. jon
    Replies:
    0
    Views:
    260
  2. Otis Hunter
    Replies:
    0
    Views:
    132
    Otis Hunter
    Jul 10, 2004
  3. Daryl Au

    Communicating error with OLE Server

    Daryl Au, Dec 26, 2004, in forum: Access Macros
    Replies:
    0
    Views:
    110
    Daryl Au
    Dec 26, 2004
  4. Ken Smith

    can't start OLE server

    Ken Smith, Feb 27, 2006, in forum: Access Macros
    Replies:
    0
    Views:
    94
    Ken Smith
    Feb 27, 2006
  5. Fesch
    Replies:
    0
    Views:
    105
    Fesch
    May 12, 2006
  6. BM
    Replies:
    1
    Views:
    118
    Steve Schapel
    Jun 19, 2006
  7. Creating Outlook appointment

    Output to Excel - EM: Microsoft Office Access Can't Start OLE Ser

    Creating Outlook appointment, Aug 22, 2006, in forum: Access Macros
    Replies:
    2
    Views:
    121
    Creating Outlook appointment
    Aug 25, 2006
  8. Paul Heinisch
    Replies:
    1
    Views:
    541
    Paul Heinisch
    Jul 9, 2007
Loading...