Update data from database

[elbartje]

Hey all

I want to make something that checks in the background if an excel file is changed, if so, I need to run a subroutine.
I can't do this on the moment someone wants to use the database because this would take to mutch time. I have to do it on a separate machine/server.

I know how to do this with an event procedure and a timer interval so it checks every 5 minutes.



The problem that I have to open access and this database for 24/7 so it keeps running.
Is there a beter way to do this ?

I was thinking with a task scheduler program or something ?

[pbaldy]

You can run a function from an autoexec macro and start the db from task scheduler. I have quite a few automated processes running that way.

[elbartje]

I was thinking in the same direction.
But since this has to run for several month's, years it has to be very stable.
And I'm not sure that this method is what I'm looking for.
Other solutions are always welcom.

[pbaldy]

I've had some running for years, so not sure that's a consideration.