Run Macro every hour?

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
 
G

Guest

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?
 
S

Steve Schapel

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro to run every hour 3
Run macro once every hour? 2
autoexec macro, dialog box pops up 14
ODBC - call failed during runing of macro 1
Can I run a macro in a stored database from an open database? 1
Compact & Repair, Open table, close table, then run macro 3
Transfer Text Macro - How to stop macro if file isn't there 1
how do I create a macro that will run after a specified time? 3

Top