How can I TransferDatabase a backend table from the frontend?

[AFSSkier]

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
database.

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?

 

[Jeff Boyce]

Kevin

Instead of transferring the table, I suspect you could "export a query".
That way, you could keep the query in the front-end.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[pietlinden]

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
database.

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?

use a workspace, open the backend database in that workspace, do what
you want, then close the workspace again.