ODBC/Security Macros wont run from command line

[TJMasters]

Hi I recently upgraded to Access 2007. When starting my MS Access macros
from the command line via scheduler that connect to teradata via ODBC I get
error 1004. If I start the same macro manually it runs fine. Have setup
trusted locations, disabled sandbox mode via regedit and still no luck any
ideas?

 

[Douglas J. Steele]

I'm not familiar with setting up ODBC connections to teradata. Does the DSN
include the appropriate user credentials, or is that picked up from context?
If the latter, is the scheduled task running under the appropriate
credentials (or, conversely, does the id under which the scheduled task is
running have the appropriate permissions)?