Microsoft Access can't start the OLE Server

  • Thread starter Thread starter Lotto
  • Start date Start date
L

Lotto

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.
 
Back
Top