Set CMD = New ADODB.Command
With CMD
Set .ActiveConnection = CONN
.CommandText = "ESTRAI"
.CommandType = adCmdStoredProc
Set prm = .CreateParameter("[INIZIO]", adDate, adParamInput, , CDate(DATA_RIF))
.Parameters.Append prm
Set RS = .Execute
Set CMD = Nothing
End With
i use this code to extract the rs value.
But during the loop the rs.movenext is extremly slow!!!!!
note:
the access table are on a lan dir
peraphs i nee to loop a disconnected recorset?
very slow movenext
-
- Administrator
- Posts: 78628
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands