Use a macro to copy database backend tables

[humph]

Is it possible to use a macro in a front end to effect a back end copy of all tables (6 tables).

Is it then possible when this copy back end is loaded on another machine to create something to help the user link the tables. If they overwrite the back end name I know it will continue to work but I am not convinced my user will use the correct name each time. I was thinking of including the date as part of the back end copy data. any ideas much appreciated.

Thanks