That code looks fine to me, and in fact, I just tested something very similar and it all works just fine (Delete and AddNew). What does your UDL look like? Are you using the ODBC driver, and what does your connection string look like?


>Hi,
>
>I am using VB6 with SP5 on Win2k with SP2 using ADO 2.6
>I am using UDL method to access my dbf file using the
>code below
>
> Set cn = New ADODB.Connection
> Set rs = New ADODB.Recordset
>
> cn.CursorLocation = adUseClient
> cn.Open "File Name=d:\winprog\test\outlet1.udl"
> rs.Open "outlet1.dbf", cn, adOpenDynamic, adLockOptimistic, adCmdTable
>
> rs.MoveFirst
> rs.Delete <------ this line give the error below
>
>Run-time error -2147467887(80040e21)
>Multi-set operation generated errors. Check each status value.
>
>Even using AddNew method also give the same problem.
>I refer to use the UDL method as it give me flexiblity
>
>Please advise and help me on the problem above