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

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