I have an application where some of the users access the data over a T-1 line. The form refresh for the T-1 users is extremely slow. The refresh is just just fine for those on the 100Base-T LAN. The SEEKs work acceptably fast (1-2 seconds), despite the fact that I'm directly accessing fairly large tables (3 million records in the parent). Then the THISFORM.REFRESH takes several minutes.

The forms are part of a formset (Yes, I now know better) of three forms. The largest form has 15-20 fields, including one pageframe, bound to the data. Most of the tables are read-only and I also have optimistic row-buffering on for the few, small tables that are editable. I have also tried only refreshing the necessary fields, and that does not seem to help.

And if it matters, DELETED is OFF and I have no deleted records. The EXE is run off of each user's C-drive. I am using the default REFRESH method.

Any suggestions or solutions would be appreciated.