Run Access Query from Excel

[MSAccess_newbie]

Hi All,

Im trying to run an access query from excel which takes parameter inputs.

I'm using the code from this link modified for my DB
http://www.ozgrid.com/forum/showthread.php?t=76848

My problem is the query pulls data from an SQL server connection which prompts for User ID and password the first time its run. When I run the code as is, it gives an error 'ODBC Connection to RegionalDB failed'
I'm suspecting its not getting passed the login prompt.
How do I send the UserID and password automatically?

 

[MSAccess_newbie]

Problem solved. This thread was very helpful.
http://bytes.com/forum/thread200547.html
I needed to re-create the linked table and check the save password option to avoid the login prompt from appearing every time it's accessed.