Erik,
Read again what Joe is doing. He's not explicitly opening the DBC, just a table in the DBC which attempts to overwrite the DBC....see? And that's where the problem arises.
>That's not true, the DBC can be opened shared and modified just like any other table. You have to use USE AGAIN.
>
>You cannot write over it or delete it while it is in use.
>
>The DBC is opened any time a contained table is opened. It is not by default set to the current database though.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
