Dim cn As New ADODB.Connection
Dim adoBtophr1 As New ADODB.Recordset cnString = ("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath & ";Jet OLEDB:Database Password=" & dbPassword)
Set cn = New Connection
cn.CursorLocation = adUseClient
cn.open cnString ...............
..............
................ adoBtophr1.Close
cn.Close
Dim adoBtophr1 As New ADODB.Recordset cnString = ("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath & ";Jet OLEDB:Database Password=" & dbPassword)
Set cn = New Connection
cn.CursorLocation = adUseClient
cn.open cnString ...............
..............
................ adoBtophr1.Close
cn.Close
pulic sub openRS(ByRef rs as ADODB.Recordset)
END SUB