*Resolved* Using Indexes in ADO on Access 97

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:

VB Code:

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.
:(

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

Bummer!!!:(