>To answer the first few questions...
>
>Most users have 14.4 or 28.8 Modems, VFP 5.0 is not currently an option, nor is running the app locally on the field rep PC.
>
>TIA,
>
>John
1.) Are U C/S? What is your data engine? If U are not C/S then transmitting entire data sets over the wire is not a good thing. Check this forum for discussion on C/S and other sites like Inquiry.Com.
2.) Install EXEs locally on remote PCs. This will help performance. If U are worried about keeping version in sync; setup a small routine in the startup program to verify the current version...
3.) Can any data files be setup as free tables on the local PCs? Data files for validation for example.
4.) Are Ur SQL statements optimized. ie; Do all of your tables have the proper indices setup?
5.) Are U using pageframes? If so, are the optimized? There is a good set of discussion items on this formum related to optimizing pageframes.
6.) Is there any other stuff in your forms that are slowing U down. Create a test form with just the grid and do some bench marking so U know where U stand. This might be the first thing I would try. It may give U justification to go to a Client/Server environment.
Well this is the third submission; hopefully it will get through... It must be snowing somewhere
Let me know if any of this stuff helped...
Steve
Steve Medvid
Systems Analyst
Environmental Resource Management