I can get you a step closer;
A reference to Access97 indicates that the MS timer Control is available for placement on an Access Form. But a search of the installed .OCX componenets on my A2K copy failed to find the correct control. ( I maynot have the correct .OCX installed on this version, but it's right in my face in VS)
But, if you can find the timer, simply set the time for One week.
Down Side: This workaround will only work if the Form isn't closed. That would reset the timer to 0. So once a week is tough...
The problem with Access is that it is the 'step-child' database. Normally not kept UP 24/7 like SQL Srvr. With SQL Srvr you could just write a stored proceedure and be done.
HTH...Toad