>Hi Doru,
>>Tables that are in the form that had me start this are always in use by >some other users on other WS on the LAN.
>
>This will make your machines first use slow.
Well, it doesn't, I'll say it again: DO FORM is always fast.
>I haven't checked all the different possibilites
>(Runtime, IDE, use of a dataenvironment, datasession),
>but in the command window and a program run under develeoper
>editition the performance is lousy and a PITA.
I wouldn't complicate things, we may lose sight of the original problem - I was only talking about tables in DE.
>
>>DO FORM is always fast, first time run or not - and it USEs the tables.
>>MODIFY FORM is slow if on the WS the tables are not open, and is quick if >the tables are open at the time it is issued. If the tables were open, but >then closed, that will not affect the speed of MODIFY FORM.
>>In testing, with test forms and tables, I also found that MODIFY FORM is >quick if the number of files in their directory is low.
>
>>The question remains, why DO FORM and MODIFY FORM behave differently in >terms of opening tables.
>Do you open your form's table with a dataenvironment ?
>That wouldbe my first guess: Do works through the DE,
>and modi form works with use.
>
>HTH
>
>thomas
Doru