Stephen,

There are a few ways to help control this, but depends on your circumstances on some of the tables in use.

In Tools/Options, the Remote Data page has a property for max records to fetch at a time. -1 = all records in the query... you can change this for global response to your applications.

If you are working with views, you might want to look into CURSORSETPROP() to update the FETCHSIZE to a specified number. Then when a view is being executed, it will only retrieve the defined limit first and continue. Then as needed, you can follow-up by getting the rest of the data with SQLMoreResults() based on your SQL connection handle.

Hope this helps guide you in the direction you needed.