run time error 2147217900

B

Barb Rheaume

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
 

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

run time error 2147217900 0
Run time error 2
Excel 2007 Macro w/ AppActivate = Run-time error '5': Invalid procedure call or argument 4
Run-time error after calling a procedure 6
Invalid SQL Run-time error '-2147217900 (80040e14)' 2
Syntax Error '1004' 6
Run Time macro based on the value in cell 4
Excel Run-time error '1004' General ODBC Error 1

Top