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?
Thanks