Running Remote Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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.
 
Back
Top