By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

MS Access Macro Scheduling Problem - Please Help

P: 1
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.
Aug 10 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
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
Aug 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.