>John,
>Reread what I wrote. Any cursors/tables opened within a private session is closed, no matter they are in DE or not.
>Cetin

Cetin,
I do respect you experience and am very greatful for all your help over the years so please don't think think I am arguing with you but I spent some time testing this yesterday. The files remain open in the private data session after the form is closed. I am sure it is the way we are doing it.

A Modal form is run at the top of a prg. The form.datasession is totally empty but the form.datasession property = 2.

Everything now happens in procedures called from within the form. If the user selects a menu button to view open invoices we run a SQL and now the tables are open in the private data session.

When we exit the form the default datasession is selected. However, the private datasession that was opened in the form still exists and the tables are still open. I found this by accident when I was opening and locking a file in a procedure called from the form init. If I got out of the form and went back in the file was still locked.

My assumption is that because we are not opening any tables in the datasession that the form is not closing them. But now that I think about it maybe if I try opening one table in the datasession it might close the session.