Hi to all,

Any tip or ideas on what Data access and search method/routine should we use in getting a recordset? we had 2.5 million records to search and have it stored in SQL server. We are just starting developing the interface and we don't want to suffer the user of waiting to get the data from the network for so long.

Thanks in advanced.