I do exactly the same thing and set the paths in the DE to the correct UNC path determined by the app, but the Databases are constructed in one directory and as I said no paths are stored. Not very helpfull sorry :(

>Yes I never use a DBC seperate from the tables.
>I think the problem is because I have to use UNC paths on this site because we have to keep our data seperate from our applications.
>
>
>>Out of interest are your tables in the same directory as the Database? Mine are and it doesn't appear to store the path at all.
>>
>>>For some reason this has never worked for me.
>>>My DBC has entries that look like the following in the property field.
>>>
>>>

>>>\\condor\ijc\ijctnd\data\unit.dbf
>>>

>>>
>>>If I try to amend them then the table becomes corrupt no matter how careful I am.
>>>
>>>Sometimes I can remove the unc reference for a single table but if I try to do them all it becomes corrupt:(
>>>
>>>I even wrote the follwing utility to remove the refernces but it does not work, I suspect because the tables themselves have backlinks to the DBC.
>>>
>>>
>>>

>>>
>>>close databases
>>>use getfile('dbc')
>>>
>>>scan for objecttype='Table'
>>>   lcProp=lower(property)
>>>   lcLeft=left(lcProp,at('.dbf',lcProp)+3)
>>>   lcFile=subs(lcLeft,rat(CHR(1),lcleft)+1)
>>>
>>>   repl property with strtran(property,lcFile,justfname(lcFile))
>>>
>>>endscan
>>>
>>>

>>>
>>>
>>>
>>>
>>>>Mark this is not a problem since the dbc only keeps the logical path to the table e.g. database is on the root folder the tables are on dbf folder under root the databse will keep a referent to dbf\tablename.dbf, being this you can copy the database plus the tables as log as you keep the same structure.
>>>>
>>>>being this the case your problem is resolved.
>>>>
>>>>>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?