avoiding logging in

TjS

Registered User.
Local time
Today, 21:49
Joined
Jul 18, 2007
Messages
126
:confused: Can anyone help me with this? I do not think it is quite possible, but you never know :confused:

I have made a form, with no startup parameters. The form is opened with restrictions (at startup, i have unchecked all the checkboxes so that in fact users cannot do anything, allright, not totally true of course, because if they use SHIFT at opening, they can do things...but that's not the point :) )

However, before selecting something within the combobox, access comes up with the Microsoft ODBC for Oracle Connect login screen.

Is there a way to avoid this, or somewhere to put in the VBA a absolute login name and password?

Thanks in advance..
 
If you use a connect string and utilize a passthrough query, you can define username, password, and DSN from within the connect string:

conn.ConnectionString = "OraOLEDB.Oracle;UID=USERNAME;pwd=PASSWORD;Data Source=DSNNAME;"
 
Utilize a passthrough query

uhm...?!? Sorry..am not that good with access to know how to write a passthrough query..but i will look for it and try to use it.

Thanks for your answer!
 

Users who are viewing this thread

Back
Top Bottom