>>>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
>>>
>>>SELECT SourceTable
>>>
>>>COPY TO MyNewTable DATABASE MyNewDatabase WITH CDX
>>>
>>>
>>
>>Ignore, I did not read the whole message.
>
>Oh, no! I need an answer and I was sooooo hopeful when you responded so quickly! <g>
Well, my first reaction was, why doesn't he COPY TO MyNewTable WITH CDX, followed by OPEN MyNewDatabaseuse and then ADD TABLE MyNewTable, since I was not aware that you could do it all in one command.