Index Property/SEEK method Problem with ADO 
Author Message
 Index Property/SEEK method Problem with ADO

I'm having a problem using the SEEK method on a table in an Access DB,
utilizing ADO 2.1:

Here is the code:
    ...
    ...
    rs.Open "billing_client", cnn, adOpenStatic, adLockPessimistic,
adCmdTable
    rs.Index = "client_id"             '<------- This is where I get an
error

    Do Until EOF(iFileNum)
        Line Input #iFileNum, sTemp

        sTokens = Split(sTemp, "^")

        For i = 0 To UBound(sTokens)
            rs.Seek Val(Trim(sTokens(i)))

            If rs.EOF Then
                rs.AddNew

                rs("Client_ID") = Val(Trim(sTokens(i)))
                ...
                ...
                rs.Update
            End If
        Next
    Loop
    ...
    ...

The error I get is "The operation requested by the application is not
supported by the provider."

I'm not sure exactly what this means.

Anyone help?

thanks,
Frank Wood



Fri, 14 Feb 2003 03:00:00 GMT  
 Index Property/SEEK method Problem with ADO
Frank , try this using     adCmdTableDirect    instead of    adCmdTable

Regards,
David Adam


Quote:
> I'm having a problem using the SEEK method on a table in an Access DB,
> utilizing ADO 2.1:

> Here is the code:
>     ...
>     ...
>     rs.Open "billing_client", cnn, adOpenStatic, adLockPessimistic,
> adCmdTable
>     rs.Index = "client_id"             '<------- This is where I get an
> error

>     Do Until EOF(iFileNum)
>         Line Input #iFileNum, sTemp

>         sTokens = Split(sTemp, "^")

>         For i = 0 To UBound(sTokens)
>             rs.Seek Val(Trim(sTokens(i)))

>             If rs.EOF Then
>                 rs.AddNew

>                 rs("Client_ID") = Val(Trim(sTokens(i)))
>                 ...
>                 ...
>                 rs.Update
>             End If
>         Next
>     Loop
>     ...
>     ...

> The error I get is "The operation requested by the application is not
> supported by the provider."

> I'm not sure exactly what this means.

> Anyone help?

> thanks,
> Frank Wood



Fri, 28 Feb 2003 10:29:19 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. ADO Index property and Seek method

2. Index Property / Seek Method In Recordset

3. Problems with the methods Index and Seek

4. Problem with ADO Seek method

5. Seek, Index on ADO Recordset

6. Seek - Index. ADO 2.1

7. Seek - Index. ADO 2.1

8. Index and Seek in ADO

9. ADO USING SEEK AND INDEXES

10. SEEK and INDEX whith ADO ???

11. ADO Seek, Index

12. Seek method on ADO data recordset?

 

 
Powered by phpBB® Forum Software