Link to home
Start Free TrialLog in
Avatar of cobp
cobp

asked on

Windows 7 task scheduler not firing off with Access.

Hello,
I have an access db that needs to open within a scheduled task on a windows 7 pc, the scheduled task has admin rights to open the access db. I also tried putting the commands in the following script file. When I click on the script or click on the db it will run ok, what could be causing the scheduled task not to run ?

Here is the code of the script that I point the schedule task to run.

START [serverpath]\databasename.mdb
EXIT
Avatar of Hypercat (Deb)
Hypercat (Deb)
Flag of United States of America image

What are the other commands that are part of this scheduled task?  Are you trying to run a query or macro within the Access database, or something else?

Also, look at the history of the scheduled task to see what exactly is happening and post any errors or Last Result information that you see there.
Avatar of cobp
cobp

ASKER

I have an autoexec inside the query.
Avatar of cobp

ASKER

All I need the scheduled task to do is open and close an access database to run a query.
Avatar of cobp

ASKER

Actually run a macro to create a file.
To open the database and run a macro, you need to add the following to the end of the command:  /x [macroname]
Avatar of cobp

ASKER

Can you give me the example ?
Avatar of cobp

ASKER

Would this be it ?

START [serverpath]\databasename.mdb /x Autoexec
ASKER CERTIFIED SOLUTION
Avatar of Hypercat (Deb)
Hypercat (Deb)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial