Index and Seek in ADO 
Author Message
 Index and Seek in ADO

Recently I'm working on migrating DAO to ADO using VB 6, and I have question
about it, does anybody can give me help?

In DAO, it supports 'Index' and 'Seek' method, but when I use ADO (2.1) to
set Index, it always raise an error. Can we still using 'Index' and 'Seek'
in ADO? If not, why there is still 'Seek' method in ADO?

Thanks in advance,
Michael



Mon, 10 Sep 2001 03:00:00 GMT  
 Index and Seek in ADO
Michael

Index and Seek are certainly in ADO 2.1, but you'll need an OLE DB provider
that supports them, which 3.51 does not.

Presuming that you are working with Jet, you'll probably have to change to
the Jet 4.0 provider when that is released, which I can only assume will be
with the commercial release to Office 2000.

The O2K beta does have a 4.0 provider, but my attempts to use Index and Seek
have been met with error messages indicating that "The provider does not
support this function". I certainly hope that the commercial release of the
4.0 provider does support Index and Seek, otherwise they are useless to
anyone using .mdb files.

Of course, all this is conjecture, because I've not been able to find any
official docs on the 4.0 provider capabilities.

Simon

Quote:

>Recently I'm working on migrating DAO to ADO using VB 6, and I have
question
>about it, does anybody can give me help?

>In DAO, it supports 'Index' and 'Seek' method, but when I use ADO (2.1) to
>set Index, it always raise an error. Can we still using 'Index' and 'Seek'
>in ADO? If not, why there is still 'Seek' method in ADO?

>Thanks in advance,
>Michael



Wed, 12 Sep 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. ADO Index property and Seek method

2. Index Property/SEEK method Problem with ADO

3. Seek, Index on ADO Recordset

4. Seek - Index. ADO 2.1

5. Seek - Index. ADO 2.1

6. ADO USING SEEK AND INDEXES

7. SEEK and INDEX whith ADO ???

8. ADO Seek, Index

9. using .index and .seek function

10. Problems with the methods Index and Seek

11. 2 questions: Code doesn't work when I split database and Seek/Index question

12. How to set controlling index before doing SEEK in Access Basic

 

 
Powered by phpBB® Forum Software