Naomi,
I am running the form from within the prg but at the very beginning. No tables are open before the form is loaded. All tables are opened from menu selections in the form.
>Are you calling this program from your form or vs. versa? If the former, then the tables should be closed (I think) after the form is released.
>
>>Ok, this is going to sound dumb but I think I just figured out something after all these years.
>>
>>I have a normal modal form with a private data session. (form.datasession = 2) I am not opening the tables in the form's data session. The form is loaded near the top of a prg and there are a number of procedures in the prg that open files for given tasks depending on user choices.
>>
>>I had always assumed that any files opened this way would be closed when the form was closed. I just realized that the private data session still exists and the files are still open after the form is released. I assume that this is because I didn't open the files inside the form's data session.
>>
>>Am I correct?
>>
>>If so where is the best place (what method) to manually close everything?
>>
>>Thanks.
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn