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

 

[Arvin Meyer]

Select Where does not approximate the speed of a Seek. Unfortunately, there
is no method as fast as the Seek method using ADO. You will need to change
your code to ADO methods.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access