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?

Any help would be appreciated.

Tony Lin