ACCESS to SQL Server code diff

In my continuing quest to upgrade my systems from ACCESS2000 toi SQL Server 2000, the following code no longer seems to work. I would appreciate any help on this..

rsTool.Open "Tooling", Cnxn, adOpenStatic, adLockReadOnly, adCmdTableDirect
rsTool.Index = "PK_Tooling"
rsTool.Seek Trim(cboTool.Text), adSeekFirstEQ
If Not rsTool.EOF Then

"PK_Tooling" is the primary key for this table.
Error" Current provider does not support the necessary interface for Index functionality.

What is it that you need to do besides opening that table?
You may change from table name to sql and specify some record range: "Select a,b,c From TBL1 Where a = 1, b=2, c=3" or something of that nature ...