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

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
.