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


M

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
 
Ad

Advertisements

M

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

Advertisements

M

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top