>I agree it is probably best not to leave tables open when they are not needed. An app I used to work on had about 30 tables to open in a form with a private datasession. It was one of those things were at first it was okay and then so many tables got opened that the form took forever to load. of course, we had to rewrite it to only get the data we need at that moment.
Are you hitting the tables directly or using views? I had one form that was horribly slow to load. Ended up creating a splash screen for that form! :D Finally had time to test it and optimise the SQL beneath the view and was able to get rid of my splash screen (nodataonload helped greatly also). :)
---------
Single field, surrogate primary keys....because it's sexier!
Third normal form is more than just a good idea.