Macro to Run Table after batch processing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allison - 26 Apr 2004 14:36 GMT

Is there a way to run a macro that will go to a make table
query and at a certain time each morning it will run the
refreshed data from an ODBC linked table. Because of
processing each day the linked tables information changes
and a batch processing is peformed each night at 12:00.
Each morning I would like to see the refreshed data after
the nightly process.

Currently, I have a linked table that has been turned into
a make table query. I want the make table query to run
automatically instead of logging into the other system by
way of Access and updating the linked table manually.
Is there a way to accomplish this???

Reply to this Message

Nikos Yannacopoulos - 27 Apr 2004 11:00 GMT

Allison,

Make a new database to be used just for the purpose. In it link to the
external file and the destination table, and copy the make table query. Then
make an autoexec macro as follows:

SetWarnings False
OpenQuery Your action query
SetWarnings True
RunCommand Exit

Finally, use Windows scheduler to open the database as required, Everytime
this happens the autoexec macro will fire, run the action query, and close
the database. The SetWarnings > False is so that it will not wait for
confirmation.

HTH,
Nikos

> Is there a way to run a macro that will go to a make table
> query and at a certain time each morning it will run the
[quoted text clipped - 9 lines]
> way of Access and updating the linked table manually.
> Is there a way to accomplish this???

Reply to this Message