Hello,

I have an application (mdb - access ) accessing a SQLServer,
How can I set up time out Record Sets on Code????..

example:

strsql1 = "SELECT Count(DISTINCT VIEW_BDLP.ID_BDLP) AS QTDE_BD" & _
" FROM VIEW_BDLP" & _
" WHERE ((" & CAMPO_DT & ") Between '" & DT & "' And '" & DT_F & "' )" & _
" AND ((VIEW_BDLP.STATUS)=" & SFECHADO1 & " OR (VIEW_BDLP.STATUS)=" & SCANCELADO1 & ")" & _
" AND ((GRUPO_GESTOR.GRUPO)=" & 1 & " Or (GRUPO_GESTOR.GRUPO)=" & 3 & " Or (GRUPO_GESTOR.GRUPO)=" & 4 & " Or (GRUPO_GESTOR.GRUPO)=" & 5 & " Or (GRUPO_GESTOR.GRUPO)=" & 7 & " Or (GRUPO_GESTOR.GRUPO)=" & 8 & " Or (GRUPO_GESTOR.GRUPO)=" & 9 & " ;"

' Set rs1 = New ADODB.Recordset
rs1.CursorLocation = adUseClient

rs1.Open strsql1, cnn1, adOpenKeyset


' Verifica se existem registros no RecordSet
If rs1.RecordCount = 0 Then

MsgBox "NÃO EXISTEM REGISTROS DISPONIVEIS NA BASE DENTRO DESSE PERÍODO - rs1"

DoCmd.Hourglass False

rs1.Close
Exit Sub

End If


TOT_BDS = rs1.Fields![QTDE_BD]

Me.ROTULOTOTBDS.Caption = TOT_BDS


rs1.Close

' *************************************

Where can i set up the property time out on record set?????



tks a lot

heron