>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
John,
Try using CREATE TABLE MyFreeTable FREE
Caroline