There is allways some compromise to do. 3-tier architecture is more flexible that a monolitic app, but it's generally slower.

To get a list of records, you can:
- Have a method in the business layer that pull out all the records needed and have methods to get each receords separately (GetNext(), GetPrevious(), etc.) So you can build a cursor in your presentation layer and fill it out with successive calls to the GetNext() method
- Use ADO to pass recordset between the layers

>I donnot really want to bypass the business layer. I am only curious how to pull data through this layer in the most effective way (i.e. speed)