Review of Microsoft.Jet.OLEDB.4.0 Connection

F

Filo

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get results from Access Database. 2
Macro doesn't work any more 0
Can't change connection property on querytable 4
ADO connection to Excel 2007 *.xlsx files? 8
When importing query from code - password required but not directl 0
how do I close the connection from excel to access after refresh? 0
can not find installable ISAM 1
USING FIELD DATA FROM USERFORM 0

Top