Hi John.

>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

Well, that was just plain dumb of me -- sorry about that!

>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.

Use CREATE TABLE FREE to fix that.

Doug