Tempermental Bat File

[Ratman11]

I have a bat file set-up to run at set time every morning on my scheduled tasks. The code in the bat file is as follows:

 START "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "H:\Service Centre\DataTeam\AccessDatabases\dbautomation.mdb"

i've been having a few glitches with it. On some days it will run, on other days it won't. I have checked the Schedule Task settings & that is all set-up correctly. It didn't run this morning, so I ran the bat file manually & it opened up the cmd screen but didn't boot up access, or my database.

Any ideas why it's doing this?

 

[smedvid]

Just a shot in the dark...
I've done similar things in the past without any issues.

try using UNC as opposed to hard coded values. i.e. H:\ = \\ServerName\NetworkShare\

Confirm the issue is specific to a single PC. Perhaps load the scheduled task onto another PC and let it run for a couple of days or so as a test...

Any other tasks running at that time?
Is PC already booted up?
Try changing the time? Perhaps network backups or maintenance activity running?


htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[mp9]

Try the Handy Access Launcher from

http://www22.brinkster.com/accessory/resources/001.shtml

- I find it to be easy and reliable.