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.