2
Answers

Multiple timers accessing single class

Ask a question
Doug Aliff

Doug Aliff

15y
5.8k
1
We have third party software that has 20 MS Access database. The software resides on two boxes: 1 production and 1 for fail over.
I'm creating an app the copies the databases at different intervals; some monthly, some daily, and some every 30 sec. I plan to use a single class (CopyDB) to handle the copying.  My question is since I have three timers running how do I ensure that I do not get a race condition or that I do not miss one of the copies (monthly, daily) because the class was being used to copy (every 30 sec). Will synclock be sufficient?

Thanks in advance for you suggestions

Answers (2)