Review of Microsoft.Jet.OLEDB.4.0 Connection
 

I am having a problem connecting to an Access table which is linked to an
oracle database table. Please note that Oracle prompts for the userId and
pswd and my goal is to not need to manually enter the Oracle userId and Pwd.
Thank you!!

strConn = "Provider=Microsoft.Jet.OLEDB.4.0; " _
& "Data Source=" & ThisWorkbook.Path & "\fbDATAWAREHOUSE.mdb" _
& "Jet OLEDB:database; User Id=myId; Password=mypwd"