Recent content by SeanP

Ok thank you for the help.

I know I am close, i don't get an error when I run this but it doesn't show up in my ODBC datasource admin window. it being the new connection I am trying to create. LAHP2 is th connection I am trying to create Function test() As Boolean Dim db As DAO.Connection Dim ws As Workspace...

The password will never expire. What are "DBQ" and "SSD"? Where do I put in the TNS servcie name? When i look at my manually created ODBC connection, the diver name is "Oracle ODBC Driver" do I put that in for the DBQ? Thank you for your help!!!!

Can someone please help me create code that when called it create an ODDC connection with an Oracle driver in an Access database. I have code that will connect but i really need one that will create it when called. Function OracleConnect() As Boolean Dim ws As Workspace Dim db As...