*Resolved* Using Indexes in ADO on Access 97

[pnish]

Is it possible to use ADO's Index property with Access 97 databases?

It appears to work fine with an Access 2000 DB using code similar to the following:

conStr "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=g:\farmersv2000.mdb"
Set cn = New ADODB.Connection
cn.ConnectionString = conStr
cn.Open    
Set rs = New ADODB.Recordset
rs.Open "farmers", cn, adOpenDynamic, adLockOptimistic, adCmdTableDirect
rs.Index = "business"

But if I use the same code on an Access 97 DB, I get the following error when I try to set the index, ie rs.Index = "business": Current provider does not support the necessary interface for Index functionality.

I'm using the same provider, so is there something extra I need to do for Access 97, or can't I do it?

Any insight would be greatly appreciated.

[pnish]

I've been doing a bit more research and it appears you can't use ADO's Index property on Access 97 databases.

Bummer!!!