• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

link access 2007 to oracle tables

I have an access 2007 databse with linked tables to an Oracle database, I have it linked by ODBC the problem is it prompts for user name and password every time opened.  Is there a way to set it up with user and password stored.
0
smurfer69
Asked:
smurfer69
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
When you created the DSN in the ODBC administrator did you provide the database username and password?
0
 
smurfer69Author Commented:
YES but it promts every time the database is opened
0
 
slightwv (䄆 Netminder) Commented:
When you created the linked tables did you tell it to save the password?

https://forums.oracle.com/forums/thread.jspa?threadID=307726
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now