Hi Jean,
We need to change the account to the current logged on account to have the
task run successfully.
1. Go to Control Panel->Scheduled Tasks
2. Double click the task to open it.
3. On the Task tab, in Run as text box, change the user account to the
current logged on user account, remember to set the password.
4. Click OK.
I think it is Windows question, to test we can schedule a simple task to
check if it works in the same situation. If it doesn't work like Access
task, you can post the Windows question to microsoft.public.windowsxp.*
Newsgroup, such as microsoft.public.windowsxp.basics.
Please feel free to reply to the threads if you have any concerns or
questions.
Sincerely,
Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <
www.microsoft.com/security>
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Jean" <
[email protected]>
|
| Alick,
|
| Thank you for the response. However, I don't understand
| what you're suggesting.
|
| As I stated in my original post I am currently trying to
| run the task with an account other than the one logged on.
| The account I am using to run the task and the account
| logged on amounts to 2 accounts.
|
| >We need to change task owner to the different user
| >account (change task
| >owner) you want the task run as;
| What do I need to change the account to?
|
| Thank you,
| Jean
|
| >-----Original Message-----
| >Hi Jean,
| >
| >We need to change task owner to the different user
| account (change task
| >owner) you want the task run as; with the Task Scheduler,
| each scheduled
| >task can be configured to run in a different account,
| however, it can't be
| >configured to run in more than two different account
| (including two
| >accounts) at the same time.
| >
| >It is the same with all the tasks, not only Access task;
| I believe other
| >tasks won't run in the same situation: logging on as
| another account.
| >
| >You can post the Windows question to
| microsoft.public.windowsxp.*
| >Newsgroup, such as microsoft.public.windowsxp.basics.
| >
| >Please feel free to reply to the threads if you have any
| concerns or
| >questions.
| >
| >
| >
| >
| >
| >Sincerely,
| >
| >Alick Ye, MCSD
| >Product Support Services
| >Microsoft Corporation
| >Get Secure! - <
www.microsoft.com/security>
| >
| >This posting is provided "AS IS" with no warranties, and
| confers no rights.
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Jean" <
[email protected]>
| >| Sender: "Jean" <
[email protected]>
| >| X-Tomcat-NG: microsoft.public.access.modulesdaovba
| >|
| >| I'm not sure which newsgroup this problem fits best so
| >| please let me know if it would be better posted in
| another
| >| newsgroup.
| >|
| >| I have an Access 2000 program that I am executing from
| a
| >| batch file as a Windows Scheduled Task with the
| following
| >| command line:
| >| "C:\Program Files\Microsoft
| >| Office\Office\MSAccess.exe" "C:\Program
| >|
| Files\TK_FrontEnd\Data\DTStats.mdb" /nostartup /runtime /cm
| >| d "Import"
| >|
| >| I then have an Autoexec macro within Access to read the
| >| cmd argument and do some processing.
| >|
| >| The scheduled task works fine if the Windows account
| >| logged on is the one running the task. However, if the
| >| task is run under a different account, Access either
| opens
| >| (I see the .ldb file appear) and does nothing or Access
| >| never opens at all. Setting Administrator permissions
| for
| >| the account running the task doesn't seem to make any
| >| difference in the outcome.
| >|
| >| Any help is greatly appreciated.
| >|
| >| Thanks,
| >| Jean
| >|
| >|
| >
| >.
| >
|
