TESTING ODBC CONNECTION

[99Chuck99]

Hi All,
I have a question, I have set up a ODBC connection using the ODBC administrator in MSACCESS to link to an Oracle database on a network server, which works great. Prompts user for ID & PASSWORD. The problem I have is if the user enters an invalid password my code starts running prior to the error measage. Is there a way to test this connection prior to any code running in case they enter an invalid password. Thanks in advance for any help.

 

[genomon]

If you have a "Do Events" it will allow this behavior - try removing it (or moving it) if so....

I have great faith in fools; self-confidence my friends call it.
-Poe