I haven't worked yet with the VFP OLEDB driver. You might want to try the ODBC driver and see if that works. If it does, then something is odd about the driver, and you can narrow the search -- might be worth a post on the VFP side of the UT.

>Hi,
>
>My UDL code shown below using VFP OLEDB driver
>
>[oledb]
>Provider=VFPOLEDB.1;Data Source=D:\WINPROG\TEST;Mode=ReadWrite|Share Deny None;Password="";Collating Sequence=MACHINE
>
>I still can't get the code below to work. Please advise
>
>
>>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