How pass credentials to Access from Excel (for onward use)

[Mark]

Hi,
I have an Excel vba sub that uses ADODB to execute a saved query on Access.
The query runs on Access but requires the user to enter a Password (the
Access query is to a linked table to Sql Server).

What I want to do is to have a userform in excel that prompts the user for
credentials and then passes them to Access, that it may in turn use for its
query to SQL Server.
I.e. I want to avoid saving the password in Access.

is that possible?
thanks
mark

 

[Mark]

Joel,
thanks for that but I don't think that is quite what I need.

What I'm trying to do is to run a saved query on access (from excel). The
Access
query gets its data from a linked table in a Sql Server Database.
So what I need to pass is the credentials for onward use in sql server.
No data is returned to excel from this query, that happens at a later stage.


The examples seem to show credentials to access the data in Access.

 

[Mark]

Joel,

thnks once again.
It is a customer request that it be done this way, not what I would have
done givena free hand (& a bigger budget)