Method seek with objects ADO in sql server

[Pierre-Yves]

Hello,



We have a big application to pass access 2000 to sql server. We are going to
use objects ADO instead of objects DAO.



In the code, we use methods seek in order to search recordsets.



We tested this method seek accessing to sql server. This method isn't
possible with a provider

OLEDB1.



A solution consist in transform "method seek" in "select where" but this
operation is too long



What is the better solution?



Thank you

 

[Perry]

You cud consider to access a server side Stored Procedure
and see whether this will speed things up

Krgrds,
Perry

 

[SA]

Pierre:

Seek does generally work fine when run against SQL tables, make sure that
the last option when you open the recordset is acCmdTableDirect and that you
open a keyset and use a server side cursor.

Secondly, however, Seek on recordsets is painfully slow in general and you
should with good design be able to use Sprocs to select and update records
which are generally faster.