>What is the best way to leave database files open during the entire time your program runs?
>
>I currently am using two database files and I'm running into stacking errors because the files open several times but do not close even though I use close all in the exit commands of forms.
>
>I have read that it is better to leave the files sit open while the program is running, how can I do this without running into a conflict while switching forms constantly?

As Edward mentioned, you should do a trace to see why the table are not closed at the end of a form.

For permanent tables, you might want to open them in the default data session in your application setup. Then, when you need them, you can save the current data session id and switch to the default data session.