Bonnie,

>I don't know what your application does, but how on earth can one Form use or process 21,000 records? You don't need to retrieve the entire table into one DataSet. You pull down what you need, as you need it. Here's an example:

What about statistical processing ?? I'm stunned again and again that pulling out large amounts of data to the client is bad per se. Sure, if you can avoid it, you should. However some types of applications just ask for it. If I want to make a statistical analysis I might HAVE to download all data before post processing.

I find too often the argument is made that its bad because the tool cannot handle that comfortably. IOW the argument is influcence by the limitations of the tool, not of what from an ideal perspective should be best.

Walter