The suggestions given are good, but they are only perpetrating an already bad situation. Sometimes it is better to just rework something rather than try to work around it over and over again. Moving your data to views is fairly simple and once done you can tweak your performance according to your network speed by using view parameters and limiting the number of records loaded at a time.

>>A recent thread talked about performance of opening a form when the form uses views of tables from a network drive.
>>A suggestion that came up in order reduce loading time was to set NoDataOnLoad = .T. for each view.
>>
>>What if the form is based on tables. Is there a way to optimize the loading of the form?
>>I have a form that needs 12 tables and it takes approx. 9-10 sec to load when my data is on a network drive.
>>
>>I took a look to DataEnvironment.OpenTables method and AutoOpenTables property. Can we do something more efficient?
>>
>>Thanks
>>Claude.
>
>Claude,
>
>One way is to open ALL your tables in the default session of your app. Then in your private datasessions for each form VFP uses a USE AGAIN format which is quicker. This puts the heaviest time burden when the EXE starts rather than when each form starts.
>
>A second way is to load your most elaborate forms when the EXE starts, but HIDE() them until they're needed.
>
>HTH
>Barbara