Kersey
Oct 5th, 2000, 04:00 PM
Hello World,
Could anyone help me with a list of (all ?) possiblities of provider information to open a ADO connection to a access 97 and/or access2000 DB.
what i mean exactly :
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cnn = New ADODB.Connection
cnn.Open "provider=Your_Provider_Here"
Set rs = New ADODB.Recordset
rs.Open "somewind", cnn, adOpenStatic, adLockReadOnly, adCmdTable
thanx,
D.
Could anyone help me with a list of (all ?) possiblities of provider information to open a ADO connection to a access 97 and/or access2000 DB.
what i mean exactly :
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cnn = New ADODB.Connection
cnn.Open "provider=Your_Provider_Here"
Set rs = New ADODB.Recordset
rs.Open "somewind", cnn, adOpenStatic, adLockReadOnly, adCmdTable
thanx,
D.