Querying a "linked" table in MS Access (from Matlab) works but not when set up as a windows scheduled task

1 view (last 30 days)
Hi,
I have a problem that I'm trying to debug. I have a Matlab script that connects to a MS Access database to query a table. This table is in fact a "link" to another table in a larger SQL database, i.e. the table is not local to that Access database, but is queryable from it.
The script works fine from an open matlab instance and works fine if I run from the command line, however if I set up a windows scheduled task to run the exact same command the script fails.
I feel it has something to do with the fact that I have an ODBC connection set up which allows me to query the linked table from MS Access. But when matlab runs by scheduled task it's not running "as me" so to speak?
Does Matlab run under a defined "user"? Which may be different when I run it vs. when the scheduler runs it?
Any info would be appreciated!
Terry

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!