asked on

MSAccss, Oracle Connection, Password Form

I thought I had this worked out with an earlier question, but I still don't have a working process.

I am trying to build a process where a connection to an oracle db is built up to the point where the password is needed. At that point, I want a password form to open and ask for the password (I already have the userID), and when the user enters the password and clicks the "Enter" button, the password gets passed back to the function that is building the oracle connection (strACSConnectionACS()), and it sends the connection over to the db for authentication and connection.

When I run it, the password form opens, but the code doesn't stop and wait for the user to enter the password. It tries to connect without the password and I get an error message.
Also, I can't figure out how to get the form closed after the user enters their password.

I've attached my code. If you see what I've got wrong please spell it out for me in detail - I can't seem to get the drift of how this is suppose to work.

Thanks, Lynn ACS.txt

mbizup

If you simply need the code to pause until the dialog box closes, change your code to this:

Function strGetACSPswdd() As STring
DoCmd.OpenForm "frmEnterACSPswd",,,,,acDialog
End Function

You may also need to add a special case to handle null/blank input so that it is not tagged onto your connection string.

ASKER CERTIFIED SOLUTION

mbizup

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Lambel

ASKER

Thanks, I used this along with some features I found to tweek the inputbox so that it hides the input characters. I think I finally have a working process.

Greatly appreciated!
Lynn