>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
You can't check this with USED/DBUSED each time you open a form?
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.