Is There A Way 2Automatically Run an Access97 Report Daily 2

[stellJess]

Hi,

A report has been created in Access97 using linked tables. The enduser does not have Access but needs the report each day. Is there a way to do this?

In advance, thanks for your assistance.

stellJess

 

[cghoga]

if you have a scheduler (i.e. nt scheduler) you could kick off a batch file each night that opens the mdb (from your machine or the server) and executes an autoexec program (built by you) that emails the report to the user (or drops it to a location on the network) and then exits out of the database.

or

if you have the Developer Edition of Access you can run a setup program on the users machine to only give them the "run-time" version. then, build/provide the user a GUI (front-end to the back-end tables) that will give them the ability to generate the report via command button, etc.

or

try Crystal Reports.

 

[dhookom]

There is a scheduler program that I have used for running reports at a specific date at

http://www.mvps.org/access/resources/downloads.htm.

Duane
MS Access MVP

 

[stellJess]

Thank you!!!