Ko,
Every solution have is benefics and is problems.
I allready program as you do (opening the tables is startup), now i open the tables as i need (but avoithing to open many tables for each form), must of the tables work behing, and if the is need data for several tables, why not create a view ???
Another reason because i do not like opening all tables at the begin, it is some off then, have little use, or they are used only in a especif part of the program and the user doesn´t have access to that part, and if i open ALL tables at beging the security maybe or maybe not compromised.
Note:
I create a little rotine to open tables, and it is always opened in USE .. SHARE AGAIN, so only the first time a table is open it cost a little more.
Question:
If in one form, the user is "creating" a client and in another is making a sale to another client, how does it stay ?
Nuno Brito
Nuno Brito