>I am a foxpro programmer but new to VB and Access.
>
>I am retrieving an entire table into an ADO record set from an Access 2000 database using the Jet 4.0 engine
>through an ADO connection using Visual Basic 6.0.
>
>The underlyig Access table has two indexed fields.
>
>I want to set the index of my record set to one of the underlying indices of the table.
>
>Unfortunately, I cannot get ADO to support indexes.
>
>I have tried setting the RecordSet.CursorLocation to both possible choices: adUseClient and adUseServer.
>
>Neither does any good.
>
>When I check the support of indexes using RecordSet.Supports(adIndex), it returns False.
>
>Is there a way to set an index on a retrieved record set in ADODB?
Not every provider are supporting indexes.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com