Autorun Macro needs to run every 10 seconds 24/7

B

backyboy

Hello, I have searched the forums and found similar topics but none so far
answers my problem which I hope someone will.

I have an AutoExec Macro which needs to run every 10 seconds 24/7. I have
achieved this by setting Start up to open a "FORM" and on Event tab set "On
Timer" equals AutoExec Macro and "Time inverval to 10000 ms.

This works well until next morning the Database locks up and took about a
week to work again.

Is it to much for MS access to handle this?

Please help.
 

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

How do I set a macro to run every 24 hours 2
Don't re-run macro for five seconds...? 8
macro to recalculate every 10 seconds 2
Code to run macro when opening an email? 2
MsgBox; if 10-seconds, assumed 'No' Clicked 3
MS Office 2007 keeps refreshing every 10 seconds 1
URGENT: get macro to pause, get module to run 5
Need to run a looped presentation with continuous audio in powerpoint 2010 0

Top