proc.CommandText = "QryPatientData"
proc.CommandType = adCmdStoredProc
Set proc.ActiveConnection = Me.Connection
proc.Parameters("@PID").Value = m_lngID
Set rsPat = proc.Execute(n)
The connection string, ActiveX Data objects version, command text, and parameters are the same in both projects. In both projects one record is affected when the sproc is executed. In the second project, the returned recordset is always closed. Why?