current provider does not support the necessary interface for index fu

[beckyh]

run time error 3251 "current provider does not support the necessary interface for index functionality"

What does this mean? I am using an Access 2000 frontend with linked tables to SQL Server.

 

[beckyh]

Here is my code

Dim cnn As Connection
Dim rstPSN As New ADODB.Recordset
Dim varPosition As Variant

Set cnn = CurrentProject.Connection
rstPSN.Open "CalculateInvTot", cnn, adOpenForwardOnly, adLockOptimistic, accmdtabledirect
cnn.BeginTrans
rstPSN.Index = "SEIiD"

total = 0
For Each varPosition In List15.ItemsSelected
rstPSN.Seek List15.ItemData(varPosition)
total = total + ListBox15.Column(2, varPosition)
Next varPosition
cnn.CommitTrans


My next question would be is there a way to achieve the same thing so my current provider understands??

Thank you everyone!

 

[RoyVidar]

I'm not sure, but I think there might be a way of getting a recordset from a SQL server table supporting index, but I don't know how. The general "rule", is that it's normally only achievable on native Access tables (and I think you'd need another cursor than forwardonly, to be able to search from start again - keyset?). I've used either the .Find method or the .Filter property in stead.

Roy-Vidar