J
John Flanagan
I am trying to have a MS Access 2003 program run during an after hours cycle.
However, the program needs to access several ODBC links with a sign on. I
was wondering if there is a way to have the system sign itself in to the ODBC
without any human intervention? I do not want to save the password when the
link is established as employee turnover would make it impossible to keep
re-establishing the links. If there is a way, I would have to only update
the log on information in 1 location, the module. Please let me know if
there is anyway to do this? Another though is...is it possible to force a
signon before the dialog box is called? I am not too familiar with how this
works. Again, any ideas would be appreciated. Thanks in advance.
However, the program needs to access several ODBC links with a sign on. I
was wondering if there is a way to have the system sign itself in to the ODBC
without any human intervention? I do not want to save the password when the
link is established as employee turnover would make it impossible to keep
re-establishing the links. If there is a way, I would have to only update
the log on information in 1 location, the module. Please let me know if
there is anyway to do this? Another though is...is it possible to force a
signon before the dialog box is called? I am not too familiar with how this
works. Again, any ideas would be appreciated. Thanks in advance.