Automated report generation by task schedular

[Matt Brown]

Is it possible to run a db by using the standard task schedular if the db has security on it?

The reason why i ask is i have tried to do this and the task stops, methinks it is because of the logon prompt is waiting for a password.
I am using a batch file to open the db, is it possible to add extra commands at the end of the batch file commands (i.e. username)so that it logs onto the db.

Reason:
I am trying to get a report to run once a week through the windows scheduler on a db.
(I know this may sound a bit of a hash but it seemed the quickest way at the time).

Is this the best option or would it be better to try and code it in Access?

Any thoughts on this wouyld be appreciated.

cheers
Matt

 

[PaddyIrishMan]

Sorry I can't be more specific but the Help on my machine has decided to give up on me.

Anyway from what I remember, you can pass the username and password to the msaccess.exe on the command line using the user and pw switches.

If you have a look in the help for command line options I'm sure you'll find it.

regards,
Patrick.