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