Hi

Anyone know how can i generate a report from Access using scheduler task. Thanks in advance

Make a macro. Name it AutoRun. It will start automatically when Access starts.
Schedule the database to open and there you have it.

You also need to use a Timer to shut it down. Set the timer on the report to enough seconds to do the job and have the OnTimer event shut down Access.

You should include a bit of VBA logic to capture errors such as a resource not being available.

Got it.Thanks