How to run Access modules unattended.

[calalli]

I have an application which currently produces a large print job. The users would like to have this run early in the morning, before they arrive in the office.

How can I set up Access to run at say 6:30 am and run a given database module ?

I can leave the PC on, and Access open over night if this is necessary.


Another issue: I need eventually to figure out how to print these reports to a file in TIFF format, to be pulled into an IXOS archive system. Any thoughts are appreciated.


TIA,
Chuck

 

[pjm]

Hi

You could use the windows task scheduler. Check out this thread for some details.

thread701-103615

pjm

 

[Scoty]

Chuck,
If you haven't found your answer and if you don't mind initiating it you can do like me. I have a simular situation where I need to run reports with no users in the DB so I just set up a timer

Sub ClickedMe_Click()
Dim StartUp as Single
StartUp = Timer + 7200 (this is 2 hours in seconds)
Do Until Timer > StartUp
DoEvents
Loop
MyModuleCode
End Sub

hth
Scoty : "Learn from others' mistakes. You could not live long enough to make them all yourself."
-- Hyman George Rickover (1900-86),