Automate Report Creation at Specific Times

[q582gmzhi]

Hi,

Is this possible?

I have a number of reports that get published onto the intranet monthly.

The same reports now need to be published hourly if possible.

The reports database sits on a NT server which also runs as the Intranet server.

So I am looking to see if NT can automatically startup Access and run the reports and output them to a specific folder in snapshot. This folders contents can then be overwritten with the latest reports and can be accessed via the intranet web pages links.

Thanks

Daz...

 

[M8KWR]

Yes it is possible.

I beleive there is 2 ways either you can keep the access program running and then use the timer interval on a form to trigger an event to export the reports.

Or you could use the windows scheduling to open up the access file, which in turn triggers an event to export the report to a specific location in your network.

I hope this helps, if yo need any help in writing any code to do this then please say.

 

[q582gmzhi]

Thanks,

I will have a look at the suggestions you made.

Daz....

 

[Jibbadiah]

Think that the Scheduled Tasks under Winnt/tasks is a good bet.

Create an executable file to open access (save as something.bat)

C:
CD\Program Files\Microsoft Office\Office
msaccess.exe c:\temp\<access_Database>

Add a Scheduled task... browse for the executable file

You can schedule it to run hourly, and you can save your password, so that it will run if you are away from your pc and your desktop is locked. I have something similar and it works a treat.



set the on start-up option to run the job that outputs your report.