>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
I open all my tables at the beginning of my application. Then I use datasessons with AutoOpen and AutoClose set to true. I never have a problem..
Craig
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer