| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How pass credentials to Access from Excel (for onward use)
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I pass the logon credentials in a macro to a ODBC query | Excel Programming | |||
| run access macro from excel pass parameter | Excel Programming | |||
| Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? | Excel Discussion (Misc queries) | |||
| Selecting a range from second row onward | Excel Programming | |||
| Pass parametres from Excel to Access query | Excel Programming | |||
Threaded Mode
