Failed to publish report to MS Office Word or Excel

I preview a report and click the button to publish the report to
Word or Excel document. It works correctly until today. It
produced below error message.

Microsoft Office Access can't complete the Output operation.

The Visual Basic code you entered contains a syntax error or the Output
procedures are not available.

Make sure there isn't a syntax error in your code. If the syntax is
correct, run Setup to reinstall Microsoft Office Access. If you want to
preserve your security or custom settings, back up the Microsoft Office
Access workgroup information file.
For information on backing up files, search the Microsoft Windows Help index
for 'backing up files'.

It occurred using toolbar icon or Tools pull-down menu. All the references
are
in place. I uninstalled the Office and reinstalled a clean copy without any
effect. In addition, it did not occur on other pcs.

Any suggestion to the possible causes and fixes are appreciated.

Re: Failed to publish report to MS Office Word or Excel

On Nov 5, 8:57 am, "Sam" wrote:
> I preview a report and click the button to publish the report to
> Word or Excel document. It works correctly until today. It
> produced below error message.
>
> Microsoft Office Access can't complete the Output operation.
>
> The Visual Basic code you entered contains a syntax error or the Output
> procedures are not available.
>
> Make sure there isn't a syntax error in your code. If the syntax is
> correct, run Setup to reinstall Microsoft Office Access. If you want to
> preserve your security or custom settings, back up the Microsoft Office
> Access workgroup information file.
> For information on backing up files, search the Microsoft Windows Help index
> for 'backing up files'.
>
> It occurred using toolbar icon or Tools pull-down menu. All the references
> are
> in place. I uninstalled the Office and reinstalled a clean copy without any
> effect. In addition, it did not occur on other pcs.
>
> Any suggestion to the possible causes and fixes are appreciated.

It sounds like a "References" issue. Open a code window in Access,
and select Tools, References from the menu. See if there are checked
items that are unavailable. I don't know which version you are using;
Access 97 should have a reference to DAO 3.51. What references are
checked for Excel, or Office? Try unchecking which ever version is
checked, and selecting an earlier version, if available.

Re: Failed to publish report to MS Office Word or Excel

I tried checking and unchecking references , it didn't work

is there anything else i can do?


"OldPro" wrote in message
news:1194288014.048588.103680@o38g2000hse.googlegroups.com.. .
> On Nov 5, 8:57 am, "Sam" wrote:
>> I preview a report and click the button to publish the report to
>> Word or Excel document. It works correctly until today. It
>> produced below error message.
>>
>> Microsoft Office Access can't complete the Output operation.
>>
>> The Visual Basic code you entered contains a syntax error or the Output
>> procedures are not available.
>>
>> Make sure there isn't a syntax error in your code. If the syntax is
>> correct, run Setup to reinstall Microsoft Office Access. If you want to
>> preserve your security or custom settings, back up the Microsoft Office
>> Access workgroup information file.
>> For information on backing up files, search the Microsoft Windows Help
>> index
>> for 'backing up files'.
>>
>> It occurred using toolbar icon or Tools pull-down menu. All the
>> references
>> are
>> in place. I uninstalled the Office and reinstalled a clean copy without
>> any
>> effect. In addition, it did not occur on other pcs.
>>
>> Any suggestion to the possible causes and fixes are appreciated.
>
> It sounds like a "References" issue. Open a code window in Access,
> and select Tools, References from the menu. See if there are checked
> items that are unavailable. I don't know which version you are using;
> Access 97 should have a reference to DAO 3.51. What references are
> checked for Excel, or Office? Try unchecking which ever version is
> checked, and selecting an earlier version, if available.
>

Re: Failed to publish report to MS Office Word or Excel

On Nov 6, 12:57 am, "Sam" wrote:
> I tried checking and unchecking references , it didn't work
>
> is there anything else i can do?
>
> >> I preview a report and click the button to publish the report to
> >> Word or Excel document. It works correctly until today. It
> >> produced below error message.
>
> >> Microsoft Office Access can't complete the Output operation.
>
> >> The Visual Basic code you entered contains a syntax error or the Output
> >> procedures are not available.
>
> >> Any suggestion to the possible causes and fixes are appreciated.
>
> > It sounds like a "References" issue. Open a code window in Access,
> > and select Tools, References from the menu. See if there are checked
> > items that are unavailable. I don't know which version you are using;
> > Access 97 should have a reference to DAO 3.51. What references are
> > checked for Excel, or Office? Try unchecking which ever version is
> > checked, and selecting an earlier version, if available.- Hide quoted text -
>
> - Show quoted text -

It helps if you give specifics. What version of Access are you
using? Have there been or are there more than one version of office
on your computer? Which ones? Reformatting your harddisk seems
extreme. There is much you could do before trying that. Chances are
you or someone else has installed some software recently that is
causing the problem. If that is the case, then uninstalling the
software may fix the problem. What software was installed?

Re: Failed to publish report to MS Office Word or Excel

On Nov 6, 2:20 am, OldPro wrote:
> On Nov 6, 12:57 am, "Sam" wrote:
>
>
>
>
>
> > I tried checking and unchecking references , it didn't work
>
> > is there anything else i can do?
>
> > >> I preview a report and click the button to publish the report to
> > >> Word or Excel document. It works correctly until today. It
> > >> produced below error message.
>
> > >> Microsoft Office Access can't complete the Output operation.
>
> > >> The Visual Basic code you entered contains a syntax error or the Output
> > >> procedures are not available.
>
> > >> Any suggestion to the possible causes and fixes are appreciated.
>
> > > It sounds like a "References" issue. Open a code window in Access,
> > > and select Tools, References from the menu. See if there are checked
> > > items that are unavailable. I don't know which version you are using;
> > > Access 97 should have a reference to DAO 3.51. What references are
> > > checked for Excel, or Office? Try unchecking which ever version is
> > > checked, and selecting an earlier version, if available.- Hide quoted text -
>
> > - Show quoted text -
>
> It helps if you give specifics. What version of Access are you
> using? Have there been or are there more than one version of office
> on your computer? Which ones? Reformatting your harddisk seems
> extreme. There is much you could do before trying that. Chances are
> you or someone else has installed some software recently that is
> causing the problem. If that is the case, then uninstalling the
> software may fix the problem. What software was installed?- Hide quoted text -
>
> - Show quoted text -

One more thing: Are you using the latest service release? Which one
are you using?

Re: Failed to publish report to MS Office Word or Excel

I'm using office 2003 with sp 3 installed on all clients, I didn't install
earlier versions of office

my pc is running windows xp sp 2,

nothing new was installed on my pc, but the problem started while I was
outputing a report to excel and my network was disconnected from the server
by accident before the output operation was done.

"OldPro" wrote in message
news:1194337402.229885.138390@o38g2000hse.googlegroups.com.. .
> On Nov 6, 2:20 am, OldPro wrote:
>> On Nov 6, 12:57 am, "Sam" wrote:
>>
>>
>>
>>
>>
>> > I tried checking and unchecking references , it didn't work
>>
>> > is there anything else i can do?
>>
>> > >> I preview a report and click the button to publish the report to
>> > >> Word or Excel document. It works correctly until today. It
>> > >> produced below error message.
>>
>> > >> Microsoft Office Access can't complete the Output operation.
>>
>> > >> The Visual Basic code you entered contains a syntax error or the
>> > >> Output
>> > >> procedures are not available.
>>
>> > >> Any suggestion to the possible causes and fixes are appreciated.
>>
>> > > It sounds like a "References" issue. Open a code window in Access,
>> > > and select Tools, References from the menu. See if there are checked
>> > > items that are unavailable. I don't know which version you are
>> > > using;
>> > > Access 97 should have a reference to DAO 3.51. What references are
>> > > checked for Excel, or Office? Try unchecking which ever version is
>> > > checked, and selecting an earlier version, if available.- Hide quoted
>> > > text -
>>
>> > - Show quoted text -
>>
>> It helps if you give specifics. What version of Access are you
>> using? Have there been or are there more than one version of office
>> on your computer? Which ones? Reformatting your harddisk seems
>> extreme. There is much you could do before trying that. Chances are
>> you or someone else has installed some software recently that is
>> causing the problem. If that is the case, then uninstalling the
>> software may fix the problem. What software was installed?- Hide quoted
>> text -
>>
>> - Show quoted text -
>
> One more thing: Are you using the latest service release? Which one
> are you using?
>

Re: Failed to publish report to MS Office Word or Excel

On Nov 6, 4:32 am, "Sam" wrote:
> I'm using office 2003 with sp 3 installed on all clients, I didn't install
> earlier versions of office
>
> my pc is running windows xp sp 2,
>
> nothing new was installed on my pc, but the problem started while I was
> outputing a report to excel and my network was disconnected from the server
> by accident before the output operation was done.
>
> "OldPro" wrote in message
>
> news:1194337402.229885.138390@o38g2000hse.googlegroups.com.. .
>
>
>
> > On Nov 6, 2:20 am, OldPro wrote:
> >> On Nov 6, 12:57 am, "Sam" wrote:
>
> >> > I tried checking and unchecking references , it didn't work
>
> >> > is there anything else i can do?
>
> >> > >> I preview a report and click the button to publish the report to
> >> > >> Word or Excel document. It works correctly until today. It
> >> > >> produced below error message.
>
> >> > >> Microsoft Office Access can't complete the Output operation.
>
> >> > >> The Visual Basic code you entered contains a syntax error or the
> >> > >> Output
> >> > >> procedures are not available.
>
> >> > >> Any suggestion to the possible causes and fixes are appreciated.
>
> >> > > It sounds like a "References" issue. Open a code window in Access,
> >> > > and select Tools, References from the menu. See if there are checked
> >> > > items that are unavailable. I don't know which version you are
> >> > > using;
> >> > > Access 97 should have a reference to DAO 3.51. What references are
> >> > > checked for Excel, or Office? Try unchecking which ever version is
> >> > > checked, and selecting an earlier version, if available.- Hide quoted
> >> > > text -
>
> >> > - Show quoted text -
>
> >> It helps if you give specifics. What version of Access are you
> >> using? Have there been or are there more than one version of office
> >> on your computer? Which ones? Reformatting your harddisk seems
> >> extreme. There is much you could do before trying that. Chances are
> >> you or someone else has installed some software recently that is
> >> causing the problem. If that is the case, then uninstalling the
> >> software may fix the problem. What software was installed?- Hide quoted
> >> text -
>
> >> - Show quoted text -
>
> > One more thing: Are you using the latest service release? Which one
> > are you using?- Hide quoted text -
>
> - Show quoted text -

Have you rebooted your server since then?

Re: Failed to publish report to MS Office Word or Excel

Yes sure , everyday


"OldPro" wrote in message
news:1194358577.363380.59040@d55g2000hsg.googlegroups.com...
> On Nov 6, 4:32 am, "Sam" wrote:
>> I'm using office 2003 with sp 3 installed on all clients, I didn't
>> install
>> earlier versions of office
>>
>> my pc is running windows xp sp 2,
>>
>> nothing new was installed on my pc, but the problem started while I was
>> outputing a report to excel and my network was disconnected from the
>> server
>> by accident before the output operation was done.
>>
>> "OldPro" wrote in message
>>
>> news:1194337402.229885.138390@o38g2000hse.googlegroups.com.. .
>>
>>
>>
>> > On Nov 6, 2:20 am, OldPro wrote:
>> >> On Nov 6, 12:57 am, "Sam" wrote:
>>
>> >> > I tried checking and unchecking references , it didn't work
>>
>> >> > is there anything else i can do?
>>
>> >> > >> I preview a report and click the button to publish the report to
>> >> > >> Word or Excel document. It works correctly until today. It
>> >> > >> produced below error message.
>>
>> >> > >> Microsoft Office Access can't complete the Output operation.
>>
>> >> > >> The Visual Basic code you entered contains a syntax error or the
>> >> > >> Output
>> >> > >> procedures are not available.
>>
>> >> > >> Any suggestion to the possible causes and fixes are appreciated.
>>
>> >> > > It sounds like a "References" issue. Open a code window in
>> >> > > Access,
>> >> > > and select Tools, References from the menu. See if there are
>> >> > > checked
>> >> > > items that are unavailable. I don't know which version you are
>> >> > > using;
>> >> > > Access 97 should have a reference to DAO 3.51. What references
>> >> > > are
>> >> > > checked for Excel, or Office? Try unchecking which ever version
>> >> > > is
>> >> > > checked, and selecting an earlier version, if available.- Hide
>> >> > > quoted
>> >> > > text -
>>
>> >> > - Show quoted text -
>>
>> >> It helps if you give specifics. What version of Access are you
>> >> using? Have there been or are there more than one version of office
>> >> on your computer? Which ones? Reformatting your harddisk seems
>> >> extreme. There is much you could do before trying that. Chances are
>> >> you or someone else has installed some software recently that is
>> >> causing the problem. If that is the case, then uninstalling the
>> >> software may fix the problem. What software was installed?- Hide
>> >> quoted
>> >> text -
>>
>> >> - Show quoted text -
>>
>> > One more thing: Are you using the latest service release? Which one
>> > are you using?- Hide quoted text -
>>
>> - Show quoted text -
>
> Have you rebooted your server since then?
>

Re: Failed to publish report to MS Office Word or Excel

On Nov 6, 10:10 am, "Sam" wrote:
> Yes sure , everyday
>
>
> > Have you rebooted your server since then?- Hide quoted text -
>
> - Show quoted text -

1)Are there any graphics in the output files? If there are, try
running without.
2) When you installed Access, did you check the box for export
converters? It defaulted to unchecked in Access 97(I don't know about
2003).

Re: Failed to publish report to MS Office Word or Excel

Sam wrote:
> Yes sure , everyday

I've not met many people that reboot the server every day.

Does your problem occur will all reports or a specific report?

Have you tried creating a new report (test) and then attempted to publish?

Have you attempted to 1) decompile, then compacted, then recompiled your
app?



>
>
> "OldPro" wrote in message
> news:1194358577.363380.59040@d55g2000hsg.googlegroups.com...
>
>>On Nov 6, 4:32 am, "Sam" wrote:
>>
>>>I'm using office 2003 with sp 3 installed on all clients, I didn't
>>>install
>>>earlier versions of office
>>>
>>>my pc is running windows xp sp 2,
>>>
>>>nothing new was installed on my pc, but the problem started while I was
>>>outputing a report to excel and my network was disconnected from the
>>>server
>>>by accident before the output operation was done.
>>>
>>>"OldPro" wrote in message
>>>
>>>news:1194337402.229885.138390@o38g2000hse.googlegroups.co m...
>>>
>>>
>>>
>>>
>>>>On Nov 6, 2:20 am, OldPro wrote:
>>>>
>>>>>On Nov 6, 12:57 am, "Sam" wrote:
>>>
>>>>>>I tried checking and unchecking references , it didn't work
>>>
>>>>>>is there anything else i can do?
>>>
>>>>>>>>I preview a report and click the button to publish the report to
>>>>>>>>Word or Excel document. It works correctly until today. It
>>>>>>>>produced below error message.
>>>
>>>>>>>>Microsoft Office Access can't complete the Output operation.
>>>
>>>>>>>>The Visual Basic code you entered contains a syntax error or the
>>>>>>>>Output
>>>>>>>>procedures are not available.
>>>
>>>>>>>>Any suggestion to the possible causes and fixes are appreciated.
>>>
>>>>>>>It sounds like a "References" issue. Open a code window in
>>>>>>>Access,
>>>>>>>and select Tools, References from the menu. See if there are
>>>>>>>checked
>>>>>>>items that are unavailable. I don't know which version you are
>>>>>>>using;
>>>>>>>Access 97 should have a reference to DAO 3.51. What references
>>>>>>>are
>>>>>>>checked for Excel, or Office? Try unchecking which ever version
>>>>>>>is
>>>>>>>checked, and selecting an earlier version, if available.- Hide
>>>>>>>quoted
>>>>>>>text -
>>>
>>>>>>- Show quoted text -
>>>
>>>>>It helps if you give specifics. What version of Access are you
>>>>>using? Have there been or are there more than one version of office
>>>>>on your computer? Which ones? Reformatting your harddisk seems
>>>>>extreme. There is much you could do before trying that. Chances are
>>>>>you or someone else has installed some software recently that is
>>>>>causing the problem. If that is the case, then uninstalling the
>>>>>software may fix the problem. What software was installed?- Hide
>>>>>quoted
>>>>>text -
>>>
>>>>>- Show quoted text -
>>>
>>>>One more thing: Are you using the latest service release? Which one
>>>>are you using?- Hide quoted text -
>>>
>>>- Show quoted text -
>>
>>Have you rebooted your server since then?
>>
>
>
>

Re: Failed to publish report to MS Office Word or Excel

it's a small office network, I turn off the server every day,

My problem occurs on all reports,

I created a test database with a test report and the same problem happened
with me, no matter wich report or database I use i always end up failing to
output from access.

yes the programmer i wor with decompiled and recompile everything with no
success in fixing it,

I don't know if it's an access problem or a windows XP error?



"Salad" wrote in message
news:13j1grg7ntdqoba@corp.supernews.com...
> Sam wrote:
>> Yes sure , everyday
>
> I've not met many people that reboot the server every day.
>
> Does your problem occur will all reports or a specific report?
>
> Have you tried creating a new report (test) and then attempted to publish?
>
> Have you attempted to 1) decompile, then compacted, then recompiled your
> app?
>
>
>
>>
>>
>> "OldPro" wrote in message
>> news:1194358577.363380.59040@d55g2000hsg.googlegroups.com...
>>
>>>On Nov 6, 4:32 am, "Sam" wrote:
>>>
>>>>I'm using office 2003 with sp 3 installed on all clients, I didn't
>>>>install
>>>>earlier versions of office
>>>>
>>>>my pc is running windows xp sp 2,
>>>>
>>>>nothing new was installed on my pc, but the problem started while I was
>>>>outputing a report to excel and my network was disconnected from the
>>>>server
>>>>by accident before the output operation was done.
>>>>
>>>>"OldPro" wrote in message
>>>>
>>>>news:1194337402.229885.138390@o38g2000hse.googlegroups.c om...
>>>>
>>>>
>>>>
>>>>
>>>>>On Nov 6, 2:20 am, OldPro wrote:
>>>>>
>>>>>>On Nov 6, 12:57 am, "Sam" wrote:
>>>>
>>>>>>>I tried checking and unchecking references , it didn't work
>>>>
>>>>>>>is there anything else i can do?
>>>>
>>>>>>>>>I preview a report and click the button to publish the report to
>>>>>>>>>Word or Excel document. It works correctly until today. It
>>>>>>>>>produced below error message.
>>>>
>>>>>>>>>Microsoft Office Access can't complete the Output operation.
>>>>
>>>>>>>>>The Visual Basic code you entered contains a syntax error or the
>>>>>>>>>Output
>>>>>>>>>procedures are not available.
>>>>
>>>>>>>>>Any suggestion to the possible causes and fixes are appreciated.
>>>>
>>>>>>>>It sounds like a "References" issue. Open a code window in Access,
>>>>>>>>and select Tools, References from the menu. See if there are
>>>>>>>>checked
>>>>>>>>items that are unavailable. I don't know which version you are
>>>>>>>>using;
>>>>>>>>Access 97 should have a reference to DAO 3.51. What references are
>>>>>>>>checked for Excel, or Office? Try unchecking which ever version is
>>>>>>>>checked, and selecting an earlier version, if available.- Hide
>>>>>>>>quoted
>>>>>>>>text -
>>>>
>>>>>>>- Show quoted text -
>>>>
>>>>>>It helps if you give specifics. What version of Access are you
>>>>>>using? Have there been or are there more than one version of office
>>>>>>on your computer? Which ones? Reformatting your harddisk seems
>>>>>>extreme. There is much you could do before trying that. Chances are
>>>>>>you or someone else has installed some software recently that is
>>>>>>causing the problem. If that is the case, then uninstalling the
>>>>>>software may fix the problem. What software was installed?- Hide
>>>>>>quoted
>>>>>>text -
>>>>
>>>>>>- Show quoted text -
>>>>
>>>>>One more thing: Are you using the latest service release? Which one
>>>>>are you using?- Hide quoted text -
>>>>
>>>>- Show quoted text -
>>>
>>>Have you rebooted your server since then?
>>>
>>
>>

Re: Failed to publish report to MS Office Word or Excel

Sam wrote:

> it's a small office network, I turn off the server every day,
>
> My problem occurs on all reports,
>
> I created a test database with a test report and the same problem happened
> with me, no matter wich report or database I use i always end up failing to
> output from access.
>
> yes the programmer i wor with decompiled and recompile everything with no
> success in fixing it,
>
> I don't know if it's an access problem or a windows XP error?
>

OK. You mentioned earlier this only occurs on your machine and no
others. Is that correct?

It's been mentioned earlier about references. Here's a comment from Van
T Dinh to someone else that had a similar problem
"1. On his computer, check the References Collection of the database
and see if any Reference is marked as "MISSING". Also, check the list
of References on his computer against the same list from (another)
working computer.

2. Check that he can send e-mails from his computer. "

You mentioned that you references seemed OK. What you didn't mention is
comparing them to the references on machines that work. Can you send
e-mails?


Someone else mentioned security issues...as if you don't have the
necessary permissions in another post.

Do you have any problems opening Word or Excel?

Can you provide your reference list (checked) and the order they are listed?