>I need to query a table on a remote SQL table with 150.000 records. I want to use ADO; i need to know how to work in this situation; after i have made my connection when i create my recordset i have to do "Select * From......" (but i have to wait too much time) or there is an other way ? Can someone help me ?
>

The article ADO Jumpstart for Microsoft Visual FoxPro Developers by John Petersen should help you http://search.microsoft.com/gomsuri.asp?n=3&c=rp_Results&siteid=us&target=http://msdn.microsoft.com/library/en-us/dnfoxgen/html/adojump.asp.