DSN UserId and Password Prompt

  • Thread starter Thread starter bslater
  • Start date Start date
B

bslater

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
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Connect to SQL with DSN without uid and password 3
Connect to SQL with DSN without uid adn password 1
Changing Oracle connection from DSN to DSN-Less 3
Close ODBC Connection / DSN vs DSN-less Connection / Access 2k2 Front-End 8
Access pass-through query using dsn-less connection not working 9
Suppressing ODBC Login Prompt 2
Linking to Oracle via ACCESS 1
Field Values When Linking to an Oracle Table 1

Back
Top