Win 7 Task Scheduler - Will not open an MS Access 2007 database

[kfschaefer]

:banghead::banghead::banghead:After doing a lot of research on how to Schedule a task ie. MS Access 2007 database, I have not found an answer on how to Schedule a task using MS Task Scheduler tool. In XP you use to have to include the msaccess.exe filepath with the start - in of the file path for the actual mdb file. I have tried various methods to set up a scheduled task to run the database file. I tried test the scheduler by placing just the executable file and it was successful, I tried it with and MS Excel file, not the executable and it worked. When I try the actual database file, nothing happens.

What is the proper setup for launching and running an Access database?

Someone suggested it could be the accdb file type that could be the isssue, any ideas?

K

 

[pbaldy]

I recall having a similar problem. I was able to get an mdb to run, which in my case was fine; I didn't need the accdb format.

 

[Thales750]

Same thing here. Any Ideas?

 

[Thales750]

I ran a bat file from Task Scheduler in Win 7 it works fine.

RunAccess.bat

start "" "C:\Program Files (x86)\Microsoft Office\Office12\MSACCESS.EXE" "C:\Data\InternetTransfer\Harris County Arrest Record Down Load.accde"

For all of you too young to remember this is a text file that will execute.