Does anyone know how to create a recordset from a Stored Procedure that is updateable?

Sample Code:

'build the command
Set cmdNew.ActiveConnection = de1.cn1
cmdNew.CommandType = adCmdStoredProc
cmdNew.CommandText = "{? = CALL dbo.sp_Patients }"
cmdNew.CommandTimeout = 90
cmdNew.CommandType = adCmdStoredProc

'bind the recordset
set rs = cmdNew.Execute

'End Sample

Somehow I know the recordset LockType needs to be set to adLockOptimistic, but I'm not sure where to do this....

thanks,
richb@pobox.com