Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Mar 2010
    Location
    northern new jersey
    Posts
    50
    Thanks
    1
    Thanked 3 Times in 2 Posts

    ODBC uses new password but Access uses old password

    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?
    Last edited by edmcguirk; 2012-05-30 at 22:08.

  2. #2
    Star Lounger
    Join Date
    Mar 2010
    Location
    northern new jersey
    Posts
    50
    Thanks
    1
    Thanked 3 Times in 2 Posts
    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.
    Last edited by edmcguirk; 2012-05-30 at 22:12.

  3. #3
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    If those are linked tables, I suggest that you delete them and relink again.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    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.
    Wendell

  5. #5
    Star Lounger
    Join Date
    Mar 2010
    Location
    northern new jersey
    Posts
    50
    Thanks
    1
    Thanked 3 Times in 2 Posts
    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.

  6. #6
    Star Lounger
    Join Date
    Mar 2010
    Location
    northern new jersey
    Posts
    50
    Thanks
    1
    Thanked 3 Times in 2 Posts
    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.
    Last edited by edmcguirk; 2012-05-30 at 21:57.

  7. #7
    Star Lounger
    Join Date
    Mar 2010
    Location
    northern new jersey
    Posts
    50
    Thanks
    1
    Thanked 3 Times in 2 Posts
    Nevermind, I solved it by creating a new ODBC link from the Linked Table Manager in Access.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •