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)
Show older comments
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
0 Comments
Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!