We have an openDBFS routine that opens all tables at app load time.. I have one form that auto generates tables, but it's so small otherwise that it's nto an issue.
-Joe

>Joe;
>
>One source of slow loading forms is due to tables being opened in the form load. The larger the table the slower the form will instantiate. That can be solved by opening all tables when the user first opens the application, at which point they are more willing to take a "hit" waiting for something to happen. My experience is that users will wait for about 1.5 second’s maximum for a form to instantiate before getting calling the IT Department.
>
>I have applications with over a million records in tables and a dozen or more tables/views on a form. These forms open quickly using this method.
>
>Tom