Running Remote Macro

[dar]

This is a two-parter. I need to transfer info to a remote database.
"Historical"
If I use the transfer command in a macro, should info go into a temp table,
then go from temp into master table via append query?

If yes to both questions, how can I run the append query remotely from the
"current" database if append query is in remote "Historical" database.

 

[Gijs Beukenoot]

Het is zò dat dar formuleerde :

This is a two-parter. I need to transfer info to a remote database.
"Historical"
If I use the transfer command in a macro, should info go into a temp
table, then go from temp into master table via append query?

If yes to both questions, how can I run the append query remotely from the
"current" database if append query is in remote "Historical" database.

I don't think you should. You could link the table (from the db
Historical) and then run an append query in your current db.