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
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.
EXIT
ASKER
I have an autoexec inside the query.
ASKER
All I need the scheduled task to do is open and close an access database to run a query.
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]
ASKER
Can you give me the example ?
ASKER
Would this be it ?
START [serverpath]\databasename. mdb /x Autoexec
START [serverpath]\databasename.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.