Pass text to password prompt when running query

[Guest]

Hello,

I have a query in my DB that requires a SQL server login the first time the
query is run. I have a password.

I want to be able to automate the password validation required for the query
using a macro (I think).

Actually, it would be great if I could just run the query upon DB opening.
I know I can program a macro to run the query upon open, but how can i
program a macro that will enter "arc8" into the 'Password' field of the SQL
Server Login window so that may select query can be run?

Any thoughts are accepted and appreciated. J. Ruben.

 

[Guest]

I tried using the SendKeys function using my macro and just specified
{ENTER}, hoping I could trip the authentication to tell me I didn't enter a
valid password.
I also specified to have the macro "wait" while the keystrokes are processed.

This didn't work. All that happened was that the authentication window
appeared and just waited for me to enter something. I appears I need
something a little more intelligent that know exactly what box to enter this
text into. Any suggestions are appreciated. Thanks, Ruben.