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 =...