I am trying to convert my code using Recordset
...

Set RS2VCP = New ADODB.Recordset
RS2VCP.Open "Select VCPName, VCPStat, VCPErrs From TempVCP", cn, adOpenDynamic, adLockOptimistic
...

to stored procedures where i get the returns of the records. how will i do these using stored procedures. do u have sample code?

thanks for any help..

cecile



The more u read, the more u do not know