Well I tried that - I see the "deleted" option on the ODBC - but I get the same results if it's checked or not.

>Yes you can but it's ODBC connection level setting. See http://www.berezniker.com/content/pages/visual-foxpro/visual-foxpro-odbc-driver
>
>>I have a remote view that connects to a VFP table (yes I know that seems odd).
>>
>>My problem is that the remote view is excluding the deleted records - which in an ideal world would be fine - however in my case I'd actually like to see them. I tried the old SET DELETED ON and SET DELETED OFF thing - but same results.
>>
>>So is there anyway for me to see the deleted records in the remote view?