>Thanks,
>the main problem are the deleted records,
>cause i can´t read the values from adDelete marked records.

You can "recall" deleted records with CancelBatch() to access their data. For example:

If myRs.Status = adRecDeleted Then
   myRs.CancelBatch(adAffectCurrent)
Endif

Use CancelUpdate() if you have not moved to another record or called the Update() method to apply a deletion operation.

>another question:
>if i receive recordsets from an ms sqlserver 7 i can´t get the cursortyp
>adOpenDynamic,it is always adOpenStatic.
>
>Do you know if this is an restriction from the sqlserver ?
>
>achim

SQL7 supports dynamic cursors. Just don't change the default cursor location for the connection or the recordset of adUseServer and this should return a dynamic rs:

myRs.open("Select * From myTable", myConn, adOpenDynamic)

HTH