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 10:21:28 -0800

problem solved -

>-----Original Message-----
>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

  • 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)
  • 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)
  • run time error 2147217900
    ... I have a macro that runs a sql stored procedure and brings ... back a record set. ... It doesn't matter which stored procedure I'm ...
    (microsoft.public.excel.programming)
  • 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)