DSN Less Links & Transfer Database

G

Greg I

I was able to create DSN less links to several oracle tables. Each time I
open the MS Access database and execute any query that touches one of these
tables the Microsoft ODBC for Oracle box comes up asking me for the uid and
pwd. I isolated the problem by deleting the links and reconnecting using DSN.
When I run now the problem dissappears. The issue is with the Link Tables
save password option. When using the transferdatabase function is there some
additional property I can set to have save password option set to yes? Below
is the string we are connecting with now.This string works fine.

"ODBC;Driver={Microsoft ODBC for
Oracle};UID=xxxxx;PWD=xxxxxxxx;SERVER=xxxxxxx;"
 

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

Table Security in Access 2013 1
DAO & ADO within the Same Application? 1
Programmatically set UID & PWD in existing ODBC DSN connection string. 1
ODBC DSN query issue 1
Setting the primary key when using DoCmd.TransferDatabase acLink 3
ADO cannot write to SQL server 8
Error 3847:"...Rewrite code to use ADO instead of DAO" 5
How to Return part of a string (Parse?) 7

Top