I read your question with interest as I have had numerious problems with Access 2000 and Windows 2003 server, although I call the MSACCESS.EXE directly from the task. What I see is C000005 errors in task scheduler. Job runs fine but then hangs at exit. The other problem I have is that I cannot get any of the jobs to run unless the server is logged in as the user specified in the task. If not logged in, the jobs simply hang at startup.
I got around the first problem by enabling Dr. Watson as the default debugger, then setting it so it basically ignored the error without generating any popups.
When I bumped into this, I worked on it for several days, trying various methods of launching the Access jobs; directly, from a batch file, used a different scheduler, etc. But I must admit I never though of calling a shortcut off a menu. The only advantage I can see from that is getting any command line switches included.
But overall, I never did find a true fix and came to the conclusion that it was a bug in the MSACCESS.EXE. Since this was something other then the current release, I highly doubt I'd ever see a fix even if I did report it, so I never bothered.
JimD.
Main Topics
Browse All Topics





by: wgoodfellowPosted on 2008-05-19 at 16:46:00ID: 21602463
Have you looked at the command shell to see if someone changed it to not close on exit? It's possible if that was changed that the access process ended, but never closed the shell that was opened for it.