Additional password question when running from cmd line

[Balex]

Hi,

I have an Access DB which is loading a whole table from a remote
Sybase DB. To do that, I've added VBA code that refers to an ODBC souce to
connect to the SYBASE DB. That code is mentioning the password that I have to
indicate to get access to the Sybase DB. I run the code as a macro. Works
fine in interactive mode, and it doesn't ask for anything, it just runs when
I double-click the macro name.

Now I am trying to have the whole thing running automatically every evening.
To do that I run it from the command line. It starts, but, contrary
to the interactive mode, it asks for the remote SYBASE DB password ! So that
cannot run unattended, which was the purpose (I started with the
definition of a scheduled job on WIN XP Pro).

Any idea how I can avoid that password question when running from the
command line ?

Thanks
Balex