Open database with task schedular problem

[zgray]

Not sure where to ask this question so ill put it here in general. Im trying to get windows server 2012 task scheduler to open my access database. When the task runs all that I see happen is the locking file will appear on my desktop and I have to go to the task manager and kill it to make it stop. I tried a .bat file to open it as well and im still getting the same thing. If I just click on the database and open it manually it runs just fine. Any help would be appreciated, thanks.

 

[DavidAtWork]

how is your .bat file, would expect something like:

START
C:\Office2000\OFFICE11\MSACCESS.EXE C:\FolderName\fileName.mdb
EXIT

I'd then have a 2nd scheduled task designed specifically to KILL the Access instance, scheduled to run later when you know the above task would have finished

@echo off
taskkill /f /IM MSACCESS.EXE


David

 

[shutzy]

i had this problem. very similar. i used the bat file to kill the access process. then used scheduler to open it. i couldnt get it to work but i resolved what i wanted to do another way.

what is it you are trying to do by closing and then reopening

 

[zgray]

I managed to get it to work in a roundabout way. It seemed that if I had run whether user is logged on or not it wouldn't open correctly. But run only when user is logged on it ran just fine. I would love to know why it wouldn't work the other way if you guys knew.