>>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 don't think there is much use in multiple table opening. Actually you should trace your app flow and open table once in 'top' form and never do this in 'child' forms. Moreover I used to open free tables once in Start Prg module and not to open them in DataEnvironment (the same way I did it in FPW).


If you're running into conflicts between forms, have you considered Private DataSessions? I've found this the best way to prevent conflicts. THe same table may be open in 2 different forms, but the odds are heavy I'll be using different indexes.

Barbara Paltiel