>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
lots of conflicting advice, don't you think?