Access macro

  • Thread starter Thread starter subs
  • Start date Start date
S

subs

i have an update query that updates the database with new data. i
want to run this update query every thursday at 12 noon EST. is there
a macro that i can use to run such query on the same day and time
every week. Please help Thanks
 
i have an update query that updates the database with new data. i
want to run this update query every thursday at 12 noon EST. is there
a macro that i can use to run such query on the same day and time
every week. Please help Thanks
Click to expand...

Your best bet is to use the Windows Scheduler to launch Access to run the
query. You can either have a dedicated database with a Startup Macro to launch
the query, or open a frontend to the database using the /X command line switch
to eXecute a macro which runs the query.
 
Back
Top