Hi Doug,
Thanks for the reply. This worked very will with a minor correction to your syntax:
OPEN DATABASE MyDatabase EXCLUSIVE
instead of
USE MyDatabase EXCLUSIVE

I found that I have many references to temp tables in my DBC that I didn't expect find. When I programatically CREATE TABLE, it seems the table is added into the currently open DBC. Then when I delete the table at the end of my function, the reference still remains in the DBC. Do I need to issue a DROP TABLE before I delete the table? This will make my DBC grow with deleted records. Is there any way to create a table without adding a record to the DBC?

Thanks,
John