Update Table Data

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

Guest

I have a macro in one database that updates a table in another database. Is
there a way to have the macro automatically run every 30 minutes or so? Any
help is greatly appreciated. Thanks.
 
You could add a form in your db with a timer event. You would have to have
the db open all the time. I would use Windows Task Scheduler to Open an
Access database with a that macro. Schedule to run when you want it. If you
name the macro "Autoexec" it will run when the db is open. Or reference the
macro name in the run command of Windows Task Scheduler.
 
Back
Top