>>
No. The problem was that I was not closing this free table in a form that was using private datasession. So, there was no way I could "close" this table afterward. That is, once the form was released I was stuck.>>
>>Hmmm. This makes no sense to me. The data environment's CloseTables() method fires before the form is released so this should not be an issue.
>>
>>Something else is going on here.
>
>I tracked the problem to the following:
>If I place the line:
>
>use in select("MyTableAlias")
>
>right before I call thisform.release() (in Exit Button Click() method), then the table can be opened exclusive later in the application. If I comment this line (Use in...), the table will not open exclusively (error 3).
Correct. A table already open cannot be "USED AGAIN" and change the exclusive status. It must be opened just once only to set EXCLUSIVE use.
>
>One more little piece of information, in case it makes a difference.
>
>The "culprit" form is based on a class in a VCX file. And the form is opened with the following line:
>
>
>DO FORM MyForm.SCX NAME oMyForm LINKED NOSHOW
>
>
>Could the above method of opening the form be the cause of the problem?