Thanks Alexandra
My problem is that my databases have the same name.
This is the brick wall I keep walking into:(
>Hi Mark you can do the following:
>
>OPEN DATABASE livedatabase
>OPEN DATABASE testdatabase
>use testdatabase!mytable IN 0 ALIAS testtable
>SELECT testtable
>COPY TO mytable DATABASE livedatabase WITH CDX
>CLOSE DATA ALL
>
>>I often have to work with 2 DBCs with the same name.
>>For example my test database and my live database.
>>
>>If I want to zap the tables in my test DBC and append into them from the live DBC I have to use the full path to the live table.
>>
>>Is there someway to set an alias to DBC different from its name?