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