>oApp.oConn = createobject("adodb.connection") >oApp.oConn.ConnectionString = [ConnectionString] >oApp.oConn.Open() >>
cnnVFP = createobj("adodb.Connection") cnnVFP.Open ("Provider=VFPOLEDB.1;Data Source=C:\FoxPro_directory;Collating Sequence=MACHINE") cnnVFP.Execute("set deleted off") &&to get deleted records with VFPOLEDB.1 o=cnnVFP.Execute("select SET('deleted') from some_table where RECNO()=1") ?o.fileds(0).value o.closeAll the Best