Macro to Run Table after batch processing

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

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