outputtofile not working in 2003

  • Thread starter Thread starter Bruce Loving
  • Start date Start date
B

Bruce Loving

I have a .ADP that used
DoCmd.OutputTo acOutputStoredProcedure, "exec
dBO.UP_REPORT79 3 ", acFormatXLS, sFile1

to export a Store Procedure.

Worked fine in Access 2000, upgraded to 2003 and
it has stopped working.

know read about Jet 4 SP 8.

any way to turn this back on?
 
Hi Bruce,

Not sure what you mean not working. Are you running into this issue:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;294410

Let me know what the error is, if any.

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| From: Bruce Loving <[email protected]>
| Subject: outputtofile not working in 2003
| Date: Thu, 10 Jun 2004 11:49:38 -0400
| Message-ID: <[email protected]>
| X-Newsreader: Forte Agent 2.0/32.652
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Newsgroups: microsoft.public.access.security
| NNTP-Posting-Host: cex-g3w9b21.uncg.edu 152.13.180.121
| Lines: 1
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10
.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.security:11354
| X-Tomcat-NG: microsoft.public.access.security
|
| I have a .ADP that used
| DoCmd.OutputTo acOutputStoredProcedure, "exec
| dBO.UP_REPORT79 3 ", acFormatXLS, sFile1
|
| to export a Store Procedure.
|
| Worked fine in Access 2000, upgraded to 2003 and
| it has stopped working.
|
| know read about Jet 4 SP 8.
|
| any way to turn this back on?
|
 
The problem turns up when running VBA-code in the form events. It has nothing to do with exporting spread sheets or tables.

The problems occurs with allmost any .ADP/.ADE we use. All .ADPs worked fine in Access 2000. Access 2003 however, terminates when running the first VBA-code and sends a report to Microsoft. Different error messages are given and 'Run time error 91: Object variable or with block variable not set' is the most common. In the VBA debugger any reference to the form object fails so it seems that Access 2003 failed in conversion after loading.

The problem does not occur when
* write-permissions are granted to the .adp file
* the file is converted to Access 2003 format and then set to read-only
* running ADP's without VBA-code
 
The problem turns up when running VBA-code in the form events. It has nothing to do with exporting spread sheets, tables or any specif VBA-code.

The problems occurs with allmost any .ADP/.ADE we use. All .ADPs worked fine in Access 2000. Access 2003 however, terminates when running the first VBA-code and sends a report to Microsoft. Different error messages are given and 'Run time error 91: Object variable or with block variable not set' is the most common. In the VBA debugger any reference to the form object fails so it seems that Access 2003 failed in converting the form reference after loading.

The problem does not occur when
* write-permissions are granted to the .adp file
* the file is converted to Access 2003 format and then set to read-only
* running ADP's without VBA-code (VBA code without reference to a form seems to run well)
 
Back
Top