>Hi All,
>
>I cannot find anywhere a discussion on the relative merits of :
>
>- Using the Data Environment to open all required files
>- Coding the Opening of files
>- Using Table Views.
>
>Any ideas, or any article one can refer me to ?
>
>Thank you.
>Michel Creppy.

I use a combination of both. Tables that I know are going to be needed are put in the DE at design time. Views are typically loaded from a datamgr class that I have for each form. Each class knows what views are needed by it and are automatically loaded in the .BeforeOpenTables() event of the DE.....which of course opens them for me. Views that are not loaded at that point because of the infrequency of use, are opened in code and closed after their use.

Steve