Update Table Data

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.
 
G

Guest

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.
 

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

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Record locks - How do I Avoid them? 1
Avoiding Errors - Re-Post 5
Access Automatically Send a notification email once a record is added 0
Run a macro and pause before running second macro 1
Compact & Repair, Open table, close table, then run macro 3
adding Columns to Table 1
Insert Date() in table field using a macro 2

Top