ODBC tables and Task Scheduler

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

Our database has linked ODBC tables that are linked to
Oracle tables. The mdb database only does some basic file
processing, i.e. there is no real user interaction. I
have set up Tasks via the Windows Task Scheduler to
perform processing tasks (using the mdb) at specific
times. The tasks perform perfectly when I am logged into
the machine, i.e they run when expected and perform as
expected. However when I am not logged into the machine
the tasks seem to "stall" at the step where it tries to
access a linked ODBC table.

Any ideas on why this might be happening? Should I expect
this to work? Any input would be greatly appreciated.
 
Kelly,

Only thing that comes to mind right away, would be authentication. Maybe
the links do not have the userid and passwords stored. When Linking the
tables, check the Save password option.

Hope this does the trick for you.

Mark

Try this and see if it does the trick. When you create the link...
 
Mark,

Thanks for the response. Yes I do have the username and
password stored with the linked tables. But I suspect you
are correct in that it has something to do with
authentication.

Kelly
 
Back
Top