ACCESS to SQL Server code diff

[Pasvorto]

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.

[RhinoBull]

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 ...