Creating index with ADO (SQL SERVER)

[MALICKA]

HI i am trying to use seek but Private Sub Class_Initialize()


rs.CursorLocation = adUseClient
rs.Open "Table", Conn, adOpenDynamic, adLockOptimistic, adCmdTableDirect

rs.Index = "primary key"

end Sub

i get the follwing error
on index

Runtime error 3251
current provider does not support the necessery inerface for index functionality


i use find menthod now its very slow
any suggestion pls