asked on
Run Access File Daily using Task Scheduler
Hi
Can someone guide me please in very simple steps how to run an Access database daily using Task Scheduler
I have tried this C:\Program Files (x86)\Microsoft Office\Office15\MSACCESS.E
but nothing
The user was Admin...
Again I would be very grateful if it is simple clear steps
Many Thanks
Can someone guide me please in very simple steps how to run an Access database daily using Task Scheduler
I have tried this C:\Program Files (x86)\Microsoft Office\Office15\MSACCESS.E
but nothing
The user was Admin...
Again I would be very grateful if it is simple clear steps
Many Thanks
Windows Server 2008Windows 7Microsoft Access
Last Comment
Dennis Johnson
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I would suggest creating a batch file. Try executing that outside of the scheduler. Once you have that working, then call the batch file from the scheduler.
<< I gave the task the appropriate admin rights to run >>
You must be running under the account of the logged in user.
Jim.
<< I gave the task the appropriate admin rights to run >>
You must be running under the account of the logged in user.
Jim.
ASKER
I do not know how to create a patch file which run this access file?
I am not too sure
I am not too sure
After manually running the command from within task scheduler and refreshing the list after 1-2 seconds (important), what is the value of the column Last Run Result?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I do not agree with that
I stopped responding partially because have given up
I stopped responding partially because have given up
I asked what was the value of the Last Run Result column, in order to start troubleshooting from somewhere, but you didn't respond.
The user is logged on to terminal server session, I created the task to run... I gave the task the appropriate admin rights to run ...the file is on a mapped drive H:\pathtoyourAccddbfile\fi
Nothing happened when it runs
Any solution
Thanks