I have a database that exports and appends just the contents of the tables into another database and this is emailed and imported into Head Office. It has worked perfectly for years. However we have now split the original database and when we use the Transfer Database command in a macro (built into a button that the user just clicks), it transfers the link rather than the contents of the linked table. I just cant seem to get my head around how to solve this.
It would work perfectly if I did the macro from the Back End, but this is usually done by an End User who has no idea what a Back End is and I dont want them going near the Back End if I can help it.
Any help would be appreciated