Gavin,

You can use SET DELETE OFF command. For example,

lcConStr = "Provider=vfpoledb;Data Source="+HOME(2)+"northwind\northwind.dbc"
oCon = CreateObject("ADODB.connection")
oCmd = CreateObject("ADODB.Command")
oRs  = CreateObject("ADODB.RecordSet")
oCon.Open(lcConStr)
oCmd.ActiveConnection = oCon
oRs.ActiveConnection = oCon
oCmd.CommandText = [SET DELETE OFF]
oCmd.Execute()
oCmd.CommandText = [ SELECT  SET("DELETED"), * FROM orders]
oRs.Source = oCmd

>Hi All,
>
>How do you select deleted records using the OLEDB Driver. I've done a:
>
>

>SELECT * ;
>    FROM mytable ;
>    WHERE DELETED()
>

>
>but I get no records returned even though there are deleted records in the table.