Automate user id and password in ODBC dialog box

  • Thread starter Thread starter Mark in Michigan
  • Start date Start date
M

Mark in Michigan

Hi all,

I'm attempting to use the windows scheduled task feature to automatically
download information via ODBC into an access db. The problem is that the
ODBC user id and password has to be entered before the data will transfer.
Is there some way to programmically enter the user id and password in the
ODBC dialog box and then "click" OK so that the procedure will continue?

I'm just a tinkerer with vb so detailed info would be much appreciated.
Thanks for any help you can provide.
 
Thanks for your reply.

I attempted to set up a pass-through query, though I've never used one
before. I did not seem to save the password in the string even though I
answered yes when prompted.

Also, do I then use SQL code to tell the query where to get the data? I
attempted this but the whole thing didn't work, got the message "OBBC call
failed - ...From keyword not found where expected.
 
Back
Top