I currently have a solution which runs on two files.
1 file is the desktop file. It has no tables in it, only shadow tables (links to tables in the main 'server' file).
The second file is the 'server' file which contains all data and tables. That way I can update the cosmetic part of the system without messing about with the data. The problem I have is that I want to add something extra and it makes sense to rename the 'server' file to be more general. Problem is, if I rename the server file, all links still point to the previous name.
Any ideas how I can change the filename and update links etc?