[mayjune]

how do i check which odbc drivers is it?

this is what the code is like

Dim ado As ADODB.Connection

Private Sub Form_Load()
    Set ado = New ADODB.Connection
    ado.ConnectionString = "Provider=MSDASQL.1;Password=ppp;Persist Security Info=True;User ID=aaa;Data Source=xxx"
    ado.Open
end sub