Results 1 to 2 of 2

Thread: *Resolved* Using Indexes in ADO on Access 97

Threaded View

  1. Jan 16th, 2003, 09:35 PM #1
    pnish
    pnish is offline

    Thread Starter
    Frenzied Member pnish's Avatar
    Join Date
    Aug 2002
    Location
    Tassie, Oz
    Posts
    1,918

    Unhappy *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:
    1. conStr "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=g:\farmersv2000.mdb"

    2. Set cn = New ADODB.Connection

    3. cn.ConnectionString = conStr

    4. cn.Open    

    5. Set rs = New ADODB.Recordset

    6. rs.Open "farmers", cn, adOpenDynamic, adLockOptimistic, adCmdTableDirect

    7. 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.
    Last edited by pnish; Jan 16th, 2003 at 09:54 PM.
    Pete

    No trees were harmed in the making of this post, however a large number of electrons were greatly inconvenienced.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width