>In all my forms, in the LOAD method, I open only those tables that are used by the form. Most forms have Private Data Session. I am thinking about creating a procedure (in a .prg file) that would open ALL tables. Then in the LOAD method of all forms to call this procedure.
>
>Does the above seem like a reasonable approach or do you see any potential problems here?

I beleive that you may slow your app down. MaxFrame has the concept of opening all tables on loading the EXE, the theory being that since those opened in a form's DE are effectively used again, they will open quicker.

However, I changed the EXE load to just the essential tables, which speeded up the EXE load considerably, and had little effect on the opening of the individual forms.

Kevin