Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 910
  • Last Modified:

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
0
cobp
Asked:
cobp
  • 5
  • 3
1 Solution
 
Hypercat (Deb)Commented:
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.
0
 
cobpAuthor Commented:
I have an autoexec inside the query.
0
 
cobpAuthor Commented:
All I need the scheduled task to do is open and close an access database to run a query.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
cobpAuthor Commented:
Actually run a macro to create a file.
0
 
Hypercat (Deb)Commented:
To open the database and run a macro, you need to add the following to the end of the command:  /x [macroname]
0
 
cobpAuthor Commented:
Can you give me the example ?
0
 
cobpAuthor Commented:
Would this be it ?

START [serverpath]\databasename.mdb /x Autoexec
0
 
Hypercat (Deb)Commented:
Yes, although I'm not entirely sure about the START command.  The one example I have in use doesn't need the START command, but it's an .accdb (Access 2010) not an .mdb. My batch file is simply:

"[serverpath or mapped drive letter]\database.accdb" /x [macroname]
exit

If the START command works for you, then by all means leave it in.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now