Does any help with the error below:
Run-time error:3251:Current provider does not support the necessary interface for index functionality.
I would like to find out where can I find the error code and the solution for the problem (See code below)
======================================================
CODE:
' Database connectivity [Active x Data Object -ADO]
' Open a recordset object in the current database
' This Connection WORKS !
Dim cnn As Connection
Dim rsttblTransactions As New ADODB.Recordset
Dim varPosition As Variant
Dim strMessage As String
Set cnn = CurrentProject.Connection
rsttblTransactions.Open "tblTransactions", cnn, adOpenKeyset, adLockOptimistic, adCmTableDirect
rsttblTransactions.Index = "keyAutoNumber"
rsttblTransactions.MoveFirst
End Sub
=======================================================
Any suggestions, direction or guidance is appreciated.
Luis
Run-time error:3251:Current provider does not support the necessary interface for index functionality.
I would like to find out where can I find the error code and the solution for the problem (See code below)
======================================================
CODE:
' Database connectivity [Active x Data Object -ADO]
' Open a recordset object in the current database
' This Connection WORKS !
Dim cnn As Connection
Dim rsttblTransactions As New ADODB.Recordset
Dim varPosition As Variant
Dim strMessage As String
Set cnn = CurrentProject.Connection
rsttblTransactions.Open "tblTransactions", cnn, adOpenKeyset, adLockOptimistic, adCmTableDirect
rsttblTransactions.Index = "keyAutoNumber"
rsttblTransactions.MoveFirst
End Sub
=======================================================
Any suggestions, direction or guidance is appreciated.
Luis
