ODBC tables and Task Scheduler

message from Kelly on 12 May 2004

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.

news.microsoft.com replied to Kelly on 12 May 2004

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...
"Kelly" <kkeyes@lw-lmco.com> wrote in message
news:c1a701c43863$91995780$a401280a@phx.gbl...

Kelly replied to news.microsoft.com on 13 May 2004

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

authentication. Maybe
When Linking the
the link...
file
into
expect

Archived message: ODBC tables and Task Scheduler (MS Access Error Message)