Microsoft Office Forums


Reply
Thread Tools Display Modes

Microsoft Access can't start the OLE Server

 
 
Lotto
Guest
Posts: n/a
 
      11-07-2008, 07:03 PM
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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
microsoft office access can't start the ole server Cher Access General 0 08-02-2006 09:47 PM
microsoft office access can't start the ole server Cher Access General 0 08-02-2006 09:46 PM
OLE! O-LE! OLE! OLE! Robby Access Forms Coding 0 12-10-2004 07:07 PM
Re: OLE Server isn't registered to register the OLE server, reinstall it. SA Access Reports 0 03-03-2004 09:22 PM
ACCESS 2003 - the ole server isn't registered to register the ole server, reinstall it Boe Access General 1 10-17-2003 01:00 PM


All times are GMT. The time now is 06:41 PM.
Microsoft Office Forums is not affiliated with Microsoft Corporation.


Welcome!
Welcome to the Microsoft Office Forums
 


Latest Threads
New user looking for shapes/templates
SargeUSMC (04-21-2014, 04:23 PM)

Mail Merging Content With High Quality
oleander (04-17-2014, 11:59 PM)

Aargh. What is this?
PeteJ (04-17-2014, 12:10 PM)

Word 2013 Insert Symbol (Not Responding)
tpthrshr (04-17-2014, 02:49 AM)

Can't save a large Word document
Josh (04-17-2014, 01:03 AM)