I am connecting an Oracle database with an Access database through Oracle ODBC Driver 11.2 .
The problem is that every time I access the database in Access, the Oracle driver requests authentication:
Is there any way to remember the username and password?
I did not find this option in the Oracle driver .
Here are two ways to resolve this:
When you are creating the link tables, you have a "Save Login ID And Password Locally" checkbox.
Microsoft URL has more information
Another way to work around this:
If you are using System DSN, you can edit the registry to include the password that is stored unencrypted (open text) at the following location:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<dsnname>\Password
It asks for the password again because at the time you linked the table with Access you probably did not check the password box, I think that's all.