Hi Kev,

The first thing I would look at is the NoDataOnLoad property for each of the views in the DE. If this is set to .F. (default) then the views will be populated with data on loading the form. Rather than opening them in code (as you seem to be suggesting), set the NoDataOnLoad property to .T. and issue a Requery() command when you need the view.

Also, a form with a lot of controls (10 pags of controls seems a lot to me) does take longer to load than smaller ones.

HTH

Liam






>Can anyone advise.
>
>I have a form with:
>
>10-page pageframe
>54 views - total of 35 base tables
>7 foxpro-dos tables
>
>The form runs perfectly fine, but it takes a very long time to actually load.
>
>The app is running on an NT server, it's fine locally, but that figures anyway.
>
>I was thinking of only opening the views/tables when they are required, that is, say, when a pageframe is activated.
>
>Is this a good idea, or should the views be left in the DE to be loaded up.
>
>Help greatly appreciated.
>Thanks
>Kev