Hi All,
I have a MS Access macro which needs to be scheduled in the Task Scheduler.
I am using the following link to schedule the macro
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "D:\Formatting Script.mdb" /x "Schedule_Macro"
The macro is scheduled and ran fine when I used my User Id in the Schedule Task.
But I want to run this macro with the permissions of another User Id. If I give the User Id and Password of another user the Task is not running at the scheduled time.
Someone please help me.
See this link, note the excerpts from it below:
http://support.microsoft.com/kb/230575
• On the Scheduler Service, instead of using a system account, log on as a user account that has Administrator rights.
Note Using the system account does not work correctly. The Office Assistant pops up and Access stops responding (hangs). Also, the system account does not have a default printer so, in that case, you could not print reports in Access.
illustrated example
---------------------------
10. Using Notepad, or any text editor, type the following lines:
C:
CD\Program Files\Microsoft Office\Office
Msaccess.exe C:\Northwind.mdb /x Macro1