ADE/ADP AC2000 DoCmd.OutputTo

B

BJ Freeman

The customer and I have the Same ADE.
I have the ADP.

Up to this morning everything worked fine.

this gets executed correctly. Shows up in the profiler as Execute
dbo.ADP_BOSWarehouseExport
DoCmd.OutputTo acStoredProcedure, "dbo.ADP_BOSWarehouseExport",
"MicrosoftExcel(*.xls)", "BOSWarehouseExport.xls", True

this has a parm and shows up inthe profiler as SELECT * FROM
"dbo"."ADP_Exprt_OrderRoutingtbl 1"
DoCmd.OutputTo acStoredProcedure, "dbo.ADP_Exprt_OrderRoutingtbl 1",
"MicrosoftExcel(*.xls)", CurrentProject.Path & "\" & "Neworders.xls", True

I get a 2757 error

if I change it to
DoCmd.OutputTo acStoredProcedure, "dbo.ADP_Exprt_OrderRoutingtbl",
"MicrosoftExcel(*.xls)", CurrentProject.Path & "\" & "Neworders.xls", True

it asks for the parm in a dialog box then executes properly.

where should I look so Access will execute this as a Storeprocedure instead
of the Select.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2K ADP Docmd Passing parm with acStoredProcedure 3
runtime error 2306 0
Delay in executing SQL statement 8
How to call open a Word doc with links from within Access 2003 1
acOutputStoredProcedure not printing Excel file 5
How to export stored procedure with parameter? 0
Excel Automation - Access wants to re-open excel sheet when finish 0
DoCmd.outputto excel problem 5

Top