>Can you confirm that when I open a view or issue a SQL statement, that all the concerned tables as opened as well and that when I close the resulting cursor that these concerned tables remain opened unless I specifically close them myself?
>
>Why? whywhywhywhywhywhy?
>

Pablo,

The SELECT command would be moving the record pointer in an instance of the table if it did not open it again for its own use. The reason the tables are not closed is to optimize future SELECTs which very well may be using the same tables (USE AGAIN is faster than USE newly).

If you adopt private data sessions there is no problem in doing a CLOSE DATA in a form's Unload event which will close all tables that that form used.

There are many times when I think something is stupid. Usually after some research I find out it was that I did not understand the entire situation.