>We need to move a number of tables and DBCs around in order to accomodate multiple compainies in our accounting system.
>
>I can remove table, move the files as needed and then add table but if I do that I loose all the detail info on the fields that is stored in the DBC. I can read and write the backlink info (using low level) in the DBF header but the info is also stored as read only in the DBC memo field. I could spend a few days writing a prg that gets the detail info, moves the table and then restores the detail info with dbsetprop() but that's a lot of work.
>
>Given all the above. Does anyone know of any easy way to move the files around?
>
>Thanks a million to anyone who can help on this one!

1) Run GenDBC[X] to get the definition of the database.
2) In the output file from GenDBC[X], find each table and put the desired path relative to the database in each CREATE TABLE call.
3) Loop through each table in the database (which you can get with ADBOBJECTS()) and append from the original locations.