Connecting Access to oracle

[Jose Martinez]

hi

Access Version 2010

I have an Access Db with linked tables to an Oracle DB and when I try to open connection Oracle ODBC Driver Connect is always asking me about a user name and password

So I had create a new connection whit ODBC data source but I can fill just the user name automatically, and not the password



I want to know how to fill paremeters using VBA when database opens the first time


thanks and have a nice day

[rpeare]

You can create your own form instead of relying on the external prompt and fill it in with the appropriate values then reconnect using the form input. Then connect using a connection string/tabledef update.

[Jose Martinez]

You can create your own form instead of relying on the external prompt and fill it in with the appropriate values then reconnect using the form input. Then connect using a connection string/tabledef update.

Thanks I found this and it works fine
Public Function OracleConnect() As Boolean
Dim ws As Workspace
Dim db As Database
Dim LConnect As String
On Error GoTo Err_Execute

LConnect = "ODBC;DSN=XXXX;UID=XXXXX;PWD=XXXXXX;SERVER=XXX XX"
Set ws = DBEngine.Workspaces(0)
Set db = ws.OpenDatabase("", False, True, LConnect)

Exit Function
Err_Execute:
MsgBox "Connecting to Oracle failed."
OracleConnect = False
End Function