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.EXE "D:\pathtoyourAccddbfile\file.accdb"

but nothing

The user was Admin...

Again I would be very grateful if it is simple clear steps

Many Thanks

ASKER CERTIFIED SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

M SOS

ASKER

Nothing happened

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\file.accdb

Nothing happened when it runs

Any solution

Thanks

Jim Dettman (EE MVE)

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.

M SOS

ASKER

I do not know how to create a patch file which run this access file?

I am not too sure

Dennis Johnson

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