>>I am hitting my head against this strange problem. In the application I am trying to open a table exclusive but get error 3.
>>
>>The table does not belong to a database.
>>I am the only one running the application.
>>No other window of the application is open.
>>Right before USEing this table I have CLOSE DATABASES ALL and CLOSE TABLES.
>>
>>Yet I still get error (file is in use, error 3) when trying to open this table.
>>
>>What could be holding this table?
>>
>>Thank you.
>
>This wouldn't be a web application and IIS be involved, would it?
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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham