Hi all,

I am trying to find a solution to a "thorny" problem.
I used to work with DAO to access databases (mostly Jet - Access97), and
when I wanted to find a specific record in the database I would either SQL
it (Select * from Table Where ...) or do a Seek operation, with a predefined
index.

Now, when I try to do the same thing with ADO, I get the following error
message - [Runtime Error 3251: The operation requested by the application is
not supported by the provider]

this happens on my assign of the Index property to "MyIndex".

    If rsSpecMeasur.EOF And rsSpecMeasur.BOF Then
    Else
        rsSpecMeasur.MoveFirst
        rsMeasurName.Index = "MyIndex"
        rsMeasurName.Seek WorkStageNum & "-" & rsSpecMeasur!MeasurementNum
        If Not rsMeasurName.EOF Then
            GetData
        End If
    End If

Please don't tell me that I need to upgrade to Access 2000 in order for this
very simple code to run??

Thanks a mill,
Rimon Rafiah

  I don't think you need to use A2K db's, but you need to be sure your
ADO code has the correct specifications when you Open the recordset.  I
haven't tested it, but you might find help in the the ADO code at
http://support.microsoft.com/support/kb/articles/Q243/4/65.ASP - with
Acess97, your .Provider could be Jet.OLEDB.3.51 (even tho it sez it's
for A2K, the ADO code would be applicable to VB6).
--
Jim in Cleveland
If you're writing to me, in my address
change "REAL_Address.see.below" to "worldnet.att.net"
 ((("What's so funny 'bout peace, love & understanding?" - Nick Lowe)))