Automate user id and password in ODBC dialog box

[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.

 

[Alex Dybenko]

Hi,
you can try to create a pass-through query to your odbc source and same
connection string for it. then use this query to download information

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Mark in Michigan]

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.

 

[Alex Dybenko]

Hi,
but what is your ODBC source exactly?

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com