ODBC uses new password but Access uses old password

Topic

New Reply

I have an Access link to an Oracle database that I have used for years. My recent upgrade to Win7 successfully set up the 32 bit ODBC driver to the Oracle database and Access successfully used it for several months. The ODBC driver is hard coded with the password by putting the “userID/password” in the user ID field of the ODBC driver.

Recently the database changed policy on the user ID and the password expired. During the time that they reset the user ID so the the password does not expire, they changed the password. I changed the userID/password in the ODBC driver and successfully tested the connection.

However the Access link still references the old userID/password and I could not change or remove the old userID/password using the Linked Table Manager in Access. I can successfully use the Access link if I overtype the correct userID and password after the automatic login fails but it occasionally results in a locked user ID with following tasks to get the user ID unlocked.

Why does the ODBC driver remember the new userID/password but Access insists on using the old userID/password? How can I fix this?

Reply | Quote

Replies

Sorry for the run-on paragraph, line breaks didn’t come through and edit does not work for me.

edit
I just learned that my company blocks features that allow paragraph breaks and also edits. I can type paragraphs and edit posts from home but not from the office.

Reply | Quote

If those are linked tables, I suggest that you delete them and relink again.

Reply | Quote

You could try using the Linked Table Manager to do the process of changing the password that is stored in the linking information in Access. Just tell it you want to relink everything and specify the new source. If that doesn’t work for some reason, then you will probably need to delete as rurib suggested.

Reply | Quote

Thanks for the suggestions. My ID is currently locked and sometimes it can take a week to get it reset. My first thought was to build a new ODBC entry and point the existing Access tables to a new driver but it may be easier to delete the linked Access tables and re-create the links.

Reply | Quote

It took me forever to get back to this database but deleting the linked tables and restoring them does not work. Access still remembers only the old credentials to the database.

I can’t seem to get Access to remember the new password.

I even built a new ODBC link and a new TNSNAMES.ORA paragraph but Access still remembers the old database and the old password when I use the Linked Table Manager.

Reply | Quote

Nevermind, I solved it by creating a new ODBC link from the Linked Table Manager in Access.

Reply | Quote