>Mike,
>
>From my testing, the DBC stores a relative path to the tables. However, if the folder the DBC is in, is a root folder, it will store a full path to the data, including the drive letter.
>
>I've been trying to find a way around this for awhile, without any solution.
What it is the problem, and why in root ??
If you store DBC and dbfs in the same (sub)folder, there will be NEVER any problem with paths. Relative path twds tables that is stored in dbc in this case is none. You can (re)position your databases&tables as u r pleased
afterwards.
Real complexity with data & paths is to handle that app always use relative path rather then hardcoded absolute path when opening their data.
Once you resolve problem with DE cursors (forms/reports) opening stubornly their hardcoded dbc paths , the rest is easy.
By entrusting some global object or fuctionality, to always supply current path to any database that is used by app, your paths become relative,
and your databases/apps trully movable.