'============================================================================
'En Modulo
Public go_Cnn as Connection
Public gs_CnnStr as String
Function ConectarBD(ByVal as_cnnstr As String) As Connection
On Error Resume Next
Dim lo_cnn As Connection
Set lo_cnn = New Connection
lo_cnn.Open as_cnnstr
lo_cnn.CursorLocation = adUseClient
Set ConectarBD = lo_cnn
End Function
'==========================================================================
Function Consulta(as_SQL As String, ByVal ao_cnn As Connection) As Recordset
On Error Resume Next
Dim lo_rs As Recordset
Set lo_rs = New Recordset
lo_rs.Open as_SQL, lo_cnn
Set Consulta = lo_rs
End Function