How can I TransferDatabase a backend table from the frontend?

How can I TransferDatabase a backend table from the frontend?

Post by QUZTU2tpZX » Wed, 09 Jul 2008 01:12:01


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?
--
Thanks, Kevin
 
 
 

How can I TransferDatabase a backend table from the frontend?

Post by Jeff Boyc » Wed, 09 Jul 2008 05:09:28

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

 
 
 

How can I TransferDatabase a backend table from the frontend?

Post by pietlinde » Wed, 09 Jul 2008 13:47:52

On Jul 7, 11:12燼m, AFSSkier < XXXX@XXXXX.COM >


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