150,000 records are a lot of records. Have you considered not pulling down those records to the workstation and instead do the processing on the server (perhaps via stored procedures)?
>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
Hector Correa