The fastest way would be calling stored procedure on remote server with Delete command inside. If it's necessary to reflect this operation immediately on front-end then use requery() afterward.
>Hey guys ----
>
>Switch over to SQLEXEC() and execute an SQL DELETE?
>
>>>Does anyone know how to delete all the records from a remote view. I have a table with 4500 records. I used DELETE ALL from a remote view of that table (I must use a remote view) but it takes like five minutes to perform that operation. I need a faster way to do this but I can't use the table directly.
>>>Thank you.
>>
>>How do you have the table buffered? Are you using ROW or TABLE buffering? If you are using ROW buffering, try table buffering the sucker and then doing the tableupdate.
>>
Edward Pikman
Independent Consultant