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. Advertising

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. Boe
    Replies:
    1
    Views:
    565
  2. Cher
    Replies:
    0
    Views:
    327
  3. Cher
    Replies:
    0
    Views:
    86
  4. Patty_d

    Microsoft Access Can't Start the OLE Server

    Patty_d, Jan 7, 2006, in forum: Access External Data
    Replies:
    1
    Views:
    387
    John Nurick
    Jan 8, 2006
  5. Robby

    OLE! O-LE! OLE! OLE!

    Robby, Dec 10, 2004, in forum: Access Forms Coding
    Replies:
    0
    Views:
    120
    Robby
    Dec 10, 2004
Loading...

Share This Page