Subject 'Table in use'
Author Dave Bullar
Help !
I have a problem with trying to drop a temporary table. Sometimes it is successful but often it is 'in use' so will not drop. I have been through all the code, and checked that all queries are closed, that they are 'unprepared' and that the transaction involved is 'committed'. I thought, that must do it. Nothing is open in design mode.

Is there any way of telling what is holding the table 'in use' ? Or any help in generally diagnosing the problem would be welcome.

[Non-text portions of this message have been removed]