I have a macro that used to TransferDatabase (copys) a table from one
Database to anyother. However when I split the database to a backend, now it
copys a link to the backend instead of coping the backend table to the other
Both databases are on the same network, in different departmentally folders.
Each database is used by 2 seperate departments that can not access each
others info, for security reasons. I have access to both.
My scheduled macro updates several other tables from the frontend of the 1st
database & I don't want to move the macro to the backend. How can I
TransferDatabase a backend table from the frontend?