Search results

Yes, U r absolutely right. My store procedure is in SQL server 2000. And I'm executing the same from MS Access. While setting the recordset object.i'm getting an error.

Thanks Hi, Can u please explain with a small snippet of example? Coz I've tried lot thru' many ways to resolve this issue but still I'm not getting any solution. Regards, Sachin

Hi, I'm having 2 functions in my application in two different modules . They are as follows. Public Function GetNextNumber() As Variant Dim strSQL As String Dim rs As Recordset GetNextNumber= Null // creating sql to execute MYSP stored procedures with 2 parameteres strSQL =...