Schedule network report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am trying to schedule a report to run from access at a particular time
each month - i am using schedule tasks to open access, but i'm not sure what
to do with the server user name and password - currently the database is
Access 2000 format it has a password for the database but it also has a
server password and user name - i am wondering how i can code these into
either the schedule task or the macro which will run this report. I'm using
windows XP

Thanks
 
Have you tried this in your task scheduler?
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
"C:\PathToDatabase\database.mdb" /user "myUsername" /pwd
"myPassword"
/x "MacroName"

Chris
 
Back
Top