How to use Index with SQL

[9695]

I have tried to use a Index of a Table in SQL serve but he keeps on telling me this mensage "Index does not exist" .But it does exist !!!!

Public cnmSQLServer As New ADODB.Connection
Public rstActividades As New ADODB.Recordset
Public rstBancos As New ADODB.Recordset

cnmSQLServer.Provider = "MSDASQL"
cnmSQLServer.Open "DSN=MSSQLServer; database=Aiccopn2;"

rstBancos.Index = "CodBanco"
rstBancos.Open "Bancos", cnmSQLServer, adOpenStatic, adLockOptimistic, adCmdTableDirect

rstBancos.Seek IDAct, adSeekFirstEQ