>Hi Cetin
>
>
>
> thank you by your help, but i must use COM.
>
>
>Luis Martinez.
OK OK I don't undertsnad why n-tiers, COM etc doesn't let you directly get into a cursor and you insist on first getting into a recordset.
I saw your code in reply to Sergey. As Sergey pointed out the problem is created recordset is Serverside, ForwardOnly cursor.
Add this before opening the connection so it creates ClientSide,Static cursor :
oc.CursorLocation= 3 && adUseClient
Cetin