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 ?

Thanks