I am using UNC paths to connect to my data sources and copying the entire folder just means I have a DBC which is still pointing back to my live files.
>Also Mark if you whant to get everything from live to test then why not copy the all files DBC, DCT, DCX, DBF, CDX, FPT.
>
>>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?