run time error 2147217900

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Barb Rheaume (anonymous_at_discussions.microsoft.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 07:15:48 -0800

Hi,

I have a macro that runs a sql stored procedure and brings
back a record set.

I can run it once and get my results. If I kick off the
macro a 2nd time, I get the run time error "procedure or
function sp_x has too many arguments specified". If I
choose end, and try the macro for the 3rd time, it works
again. It's almost like I'm not disconnecting
something. It doesn't matter which stored procedure I'm
running (several similar), it's always the 2nd try after a
successful run. If I run sp_1, and my 2nd try is for
sp_3, I will get stopped for the same reason.

Does anyone have any ideas?

Thanks,

Barb

Relevant Pages

  • run time error 2147217900
    ... >back a record set. ... >choose end, and try the macro for the 3rd time, it works ... It doesn't matter which stored procedure I'm ...
    (microsoft.public.excel.programming)
  • Re: Error 2950
    ... What is the error message? ... It is intriguing to note that you seem to be using the macro to close a form, and then open the same form again. ... Steve Schapel, Microsoft Access MVP ... the macro does run the stored procedure ...
    (microsoft.public.access.macros)
  • Error 2950
    ... So I built a macro to launch a pre-built package. ... an append qry. ... the macro does run the stored procedure ...
    (microsoft.public.access.macros)
  • Send SMTP Mail from a Macro/Stored Procedure
    ... I would like to be able call SMTP from a macro or stored procedure that ... different based on selected data in a recordset and where I could ...
    (comp.sys.ncr)
  • MailMerge DataSource problem
    ... I have a DOT template which runs a ... In the macro, I have an ADO connection to get my ... because the stored procedure is probably not returning ...
    (microsoft.public.word.mailmerge.fields)