Run Macro every hour?

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

Guest

I have an access database that is linked to an SQL server, and I have setup
append and delete queries to manage the transfer and storage of records
between the two. I have created a macro that runs these queries, but I need
this macro to run at HH:15 every hour - is there an easy way for me to do
this? Windows Task Scheduler only allows me to run daily (or greater), so I
cannot use it to automate this task.

Thanks in advance,

JDA
 
I use Windows task scheduler and one task is run every hour and another every
hour and 15 minutes. What version of Windows are you running?
 
Justin,

I agree with Chris that Task Scheduler is a lot more flexible than you
imply.

Besides that, using action queries to put your data into SQL Server
tables seems a bit odd. Why not simply link the SQL Server tables
directly to your Access application, and have your data entry and
editing apply directly to these tables?
 
Back
Top