ODBC/Security Macros wont run from command line

T

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?
 
D

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)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MSAccess 2003 mdb file does not work well in MSAccess 2007 1
passing odbc parameters via the command line 1
MS Access 2000 mdb file does not work well in MS Access 2007 1
Encrypted macros from trusted location 3
VBA code won't run, even with Macro Security set to Enable All Macors 9
Access 2007 - Macros Not Working Properly 6
Access 2007 - Error 2538 - macros cannot be run in 'disabled' mode . .. ??? 1
from access using automation run excel macro 2

Top