Thanks for the reply guys!

Well we've re-thought our approach and found a workaround by including "TOP n" on our SQL statements, so we only fetch a few records at a time and just ask the user to requery for more specific data.