I want to use an ADO connection to an Access 2000 database but I don't want to use SQL to make the connection. I want to use the tables index to sort the records and make the connection. I've tried this:

Set dbConnect = New ADODB.Connection
With dbConnect
.ConnectionString= "Provider=Microsoft.JET.OLEDB.4.0; Data Source=" & dbLocation
.CursorLocation = adUseClient
.Open
End With

recSet.Open "table",dbConnect,adOpenKeyset,adLockOptimistic, adCmdTableDirect

recSet.Index = "tableIndex"

But This will not work.

With DAO this would work will no problems. Any idea???

Thanx in Advance.