Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DSN UserId and Password Prompt
Hi all, I was hoping I could get some help for the following problem. I a a very novice programmer, so it may be an easy solution that I a overlooking. Basically, I want my VBA code to open an oracle databas via DSN (or not, whichever is easier) and prompt the user to ente their id and password like you were logging into the database vi WinSQL or something. If that makes any sense. Any thoughts? Thanks, Bria -- bslate ----------------------------------------------------------------------- bslater's Profile: http://www.excelforum.com/member.php...nfo&userid=176 View this thread: http://www.excelforum.com/showthread.php?threadid=26249 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DSN UserId and Password Prompt
Create a dialog that prompts the user for his/hers userid and password.
Call this dialog on the workbook_open event on the click event for the ok button on the dialog attach code to validate the user id and password and then open the oracle database. "bslater" wrote in message ... Hi all, I was hoping I could get some help for the following problem. I am a very novice programmer, so it may be an easy solution that I am overlooking. Basically, I want my VBA code to open an oracle database via DSN (or not, whichever is easier) and prompt the user to enter their id and password like you were logging into the database via WinSQL or something. If that makes any sense. Any thoughts? Thanks, Brian -- bslater ------------------------------------------------------------------------ bslater's Profile: http://www.excelforum.com/member.php...fo&userid=1760 View this thread: http://www.excelforum.com/showthread...hreadid=262490 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
msquery prompt for password | Excel Discussion (Misc queries) | |||
Password Prompt | Excel Discussion (Misc queries) | |||
Password Prompt | Excel Discussion (Misc queries) | |||
Web Query - UserID/Password Protected Textbox | Excel Programming | |||
FileSystemObject CopyFile with UserID/Password | Excel Programming |