Delete Temporary table

[shylock]

I am trying to delete a temporary table but get an error when executing DoCmd.DeleteObject actable, "TempServicetbl". The error is: "Run-time error '3211':: The database engine could not lock the table 'TempServiceTbl' because it is already in use by another person or process."



Since I am the only person using it, it must be another process but the only application using it is the one I'm trying to exit. I want to "clean up" before exiting so that the next time the application runs it will create a 'fresh' temporary table. How can I release the lock on this table so it can be deleted? Does it really need to be deleted or will the next iteration over-write the temp table with a new one? I think it probably will, but is that the proper thing to do?

[pbaldy]

I think it will get over-written, but personally I wouldn't delete/create it, I'd empty it and populate it.

[isladogs]

Agree that there is no need to delete it as it would be overwritten.
Also agree with just emptying and repopulating...but both methods will cause your file size to increase by a similar amount and the latter method may be slightly slower.

The fact that you can't delete the temp table suggests a recordset or query based on that process is still in use.
After use always set recordsets to nothing

[pbaldy]

I tested that line on a table in a test db that wasn't opened or accessed in any way, got that same error.

[Micron]

As did I - no error and table was deleted.

[pbaldy]

I'm a dope. The test form I used had a hidden subform pointing to that table.