Solved

link access 2007 to oracle tables

Posted on 2011-09-29
3
243 Views
Last Modified: 2012-05-12
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
Comment
Question by:smurfer69
  • 2
3 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36815879
When you created the DSN in the ODBC administrator did you provide the database username and password?
0
 

Author Comment

by:smurfer69
ID: 36815941
YES but it promts every time the database is opened
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 36816646
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question