Trying to open a table and copy it into a new database, but I keep getting an error along the lines of "...already exists as part of a database..." on the COPY TO command. The new database is totally empty. What gives? I didn't put all the code in here, but the databases are in different locations as well.

CREATE DATABASE MyNewDatabase

USE MySourceTable SHARED IN 0 && From original database location

SELECT SourceTable

COPY TO MyNewTable DATABASE MyNewDatabase WITH CDX