Automate Append Query to Run Whenever New Records Post

[Katie D]

I have an append query that copies records from table 1 in Db1 to table 2 in
Db2. The records originate peridically from another program, and are sent to
Db1 which is in a secure location, and then I append them to an identical
talbe in a database in another location where multiple users will be able to
look at and use them. I don't however how to automate (a macro?) the append
so that as soon as records hi

 

[John W. Vinson]

On Fri, 16 May 2008 14:11:00 -0700, Katie D <Katie

I have an append query that copies records from table 1 in Db1 to table 2 in
Db2. The records originate peridically from another program, and are sent to
Db1 which is in a secure location, and then I append them to an identical
talbe in a database in another location where multiple users will be able to
look at and use them. I don't however how to automate (a macro?) the append
so that as soon as records hi

Access doesn't have table triggers, which could do this in SQL/Server. What
you'll need to do is run BOTH append queries from a Macro or (better) from VBA
code. How are you executing the append query now?

 

[Katie D]

Now I just run the append query manually whenever I need to. But I want it
to run automatically when new records hit the first table; those are coming
from an outside program automatically and I have no control over that. How
would I set up a Macro to automatically run the appends? I don't know how to
do VBA code....

 

[Margaret Bartley]

What is putting the data into the first table?
If it is a script of some kind, can it be rewritten to run a macro to import
the data to the second database?
If so, then you would have to create a macro in your second database that
that either runs code or runs queries, and then invoke that macro with a
CommandLine argument.

The syntax for that statement is in the Help system, under Startup
Command-Line options.
These options includes the full pathname of not only the database in which
the macro resides, but also the full pathname of the MSACCESS.EXE
executable. If it is a secure database, it may or may not need the password
and or workfile.