where to put the ADO cmds..FormLoad?
Posted on 2004-04-06
I have a Timer that will be running a query to see if any records need to be processed
Should I put the whole ado connection stuff in the timer, or should I put the DIMming in the Formload, and Closing in the Unload?
Dim cnBC As New ADODB.Connection
Dim rsBC As New ADODB.Recordset
Dim strConnect As String
Dim tsql As String
strConnect = "Provider= Microsoft.Jet.OLEDB.4.0; Data Source = d:\db\data.mdb; Persist Security Info = False"
tsql = "Select * from AAA WHERE Processed = 'Y' "
rsBC.Open theBCsql, strConnect, adOpenForwardOnly, adLockPessimistic
If NOT rsBC.EOF Then
Set rsBC = Nothing