>Hi Denise
>
>You could also consider something called Citrix Winframe or Microsoft Terminal Server. These products let your WAN users run the program and only "screen shots" are sent to them.

One thing that will help performance, especially during startup, is to place the actual .exe local to each geographically distributed location. This does not ehance the query response time but can dramitically cut down the amount of time a user has to wait to get into the app.

Also, I think you mentioned that the data was in SQL server. Is this so, do you know? If so they might very well be using remote views. The connections and properties for these views can be tweaked to increase performance. In the Advanced Options there are settings for Fetch as Needed and the number of records to fetch at a time.

If you are using SQL Server the creation of stored procedures to create your cursors will make it so that only the records you need are pulled back across the wire and also, the code to parse the data and create the cursor is executed on the SQL Server machine.

HTH,
George