Execute code at specific time interval

I have two databases developed in access .I just want to update my db.

After every 5 minute it will check one database entries of one database and make updates on another database according first database.

So the code written file must be executed at every 5 min without loading page in the browser or user access.
Who is Participating?
hbustanConnect With a Mentor Commented:
You will need a development application such as VB or VB.Net where it uses a timer set to 5 minutes and makes the updates accordingly.

It should run on any machine that doesn't switch off - of course a server would be recommended
RyanConnect With a Mentor Project Engineer, ElectricalCommented:
You can let an application do it on its own timer as suggested, or you can create a script to run your query and call it from a task scheduler.

I would expect the application would work better, but the script won't require you to own any development software.
Are the answers provided not sufficient?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.