README for TIMERDLL
-------------------

*** HOW TO USE IT

1) Put the TIMERDLL.DLL file somewhere in your path
2) In your Access database, put the following declarations

'
' TimerDLL Functions
'
Declare Function SetAccessTimer Lib "timerdll.dll" (ByVal millisec%) As Integer
Declare Sub KillAccessTimer Lib "timerdll.dll" ()

3) To begin using the timer dll, call SetAccessTimer with the interval in milliseconds that you want the timer to go off. The function will return TRUE if it was successful in establishing the timer, and false if anything failed. At the end of each interval, the timerdll will cause Access to run the script named "TimerScript" (see caveats below). To kill the timer, just call the subroutine KillAccessTimer.

*** CAVEATS

0) This is demonstration code ONLY. This dll will work for a bunch of simple cases, but will need to be extended if more robustness or added features are needed. There are (I hope) enough comments in the code to allow a reasonably knowledgeable Windows programmer extend this easily.
1) You can only have one timer. Trying to start two timers will fail.
2) You can't set an interval greater than about 32000 milliseconds
3) There isn't very good error reporting from the dll. If something fails, you're not told what it is.
4) Care must be taken that you start the timer only AFTER you're sure that the TimerScript (or any ABC functions, etc it calls) work. If an error occurs and your timer interval is small enough, you might not be able to fix the error or stop the timer before the next timer interval ends and another error pops up. Thus, you'd have to reboot before you could fix the problem.
5) What happens if two instances of Access on the same machine try to use the timer dll is unspecified. Try this only at your own risk. I suspect that it won't work.