Index Property/SEEK method Problem with ADO
I'm having a problem using the SEEK method on a table in an Access DB,
utilizing ADO 2.1:
Here is the code:
...
...
rs.Open "billing_client", cnn, adOpenStatic, adLockPessimistic,
adCmdTable
rs.Index = "client_id" '<------- This is where I get an
error
Do Until EOF(iFileNum)
Line Input #iFileNum, sTemp
sTokens = Split(sTemp, "^")
For i = 0 To UBound(sTokens)
rs.Seek Val(Trim(sTokens(i)))
If rs.EOF Then
rs.AddNew
rs("Client_ID") = Val(Trim(sTokens(i)))
...
...
rs.Update
End If
Next
Loop
...
...
The error I get is "The operation requested by the application is not
supported by the provider."
I'm not sure exactly what this means.
Anyone help?
thanks,
Frank Wood