Opening Connection to Acces DB 97/2000

[Kersey]

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.