| Subject | 'Table in use' |
|---|---|
| Author | Dave Bullar |
| Post date | 2001-05-05T22:06:06Z |
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.
Thanks
Dave.
[Non-text portions of this message have been removed]
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.
Thanks
Dave.
[Non-text portions of this message have been removed]