When you work with remote data it's the best to limit amount of data transfered otherwise your application will be slow. You can let user to specify what data they want to see and limit there choices that program don't have to pull whole table over. Or you can use paging. However ADO doesn't provide any special mechanism for that.

>I have read this article, but it speaks about commands and property to use; i need to know which is the best choice between Select all my records in the Load event of my form (and wait) or to select a portion of the table (and i don't know how; i think i need to use PageSize, CacheSize Properties) and select again each time i need new data.
>
>What do you think about this problem. All the example i have found show "Select * From....".
>
>Thanks
< snip >