Results 1 to 2 of 2
  1. #1
    JayGBardo1 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2017
    Location
    Gurnee IL
    Posts
    1

    My Linked Oracle Database works with correct or incorrect password

    I have a pass through query that clears records on oracle table.
    The connection string is long...and includes USerID and Password for access to the Oracle Table.
    It works as intended.

    However, down the road, the passwords will change and I will need to update about 150 pass-through queries from Access.


    I know how to do this by concatenating a new Connection string with the new password embedded and then access the QueryDefs collection to find all my pass-throughs.
    So I have a VBA script to this. So far, so good.

    However I noticed that once I execute the Passthrough query in the Passthrough SQL environment in Access I can change the password in the string manually, or remove it completely and the PT query still executes successfully; I can write some other SQL code (to clear some other table) and it still works.

    I find this very odd. Usually the problem is, "I can't connect"...what am I doing wrong. In this instance the password must be held in memory.
    Anyone have an experience like this?

    JayGBardo1

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I suggest you talk to your Oracle DBA. He/she should be aware of users/passwords, related permissions and technical details including file tnsnames.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access DB does not open with correct password
    By charitha in forum Security
    Replies: 6
    Last Post: 06-17-2017, 03:07 AM
  2. Combobox with linked Oracle table
    By Peter_ in forum Forms
    Replies: 2
    Last Post: 01-08-2016, 07:46 AM
  3. Replies: 6
    Last Post: 04-05-2015, 07:33 AM
  4. Replies: 5
    Last Post: 12-28-2012, 02:48 AM
  5. Oracle password
    By thart21 in forum Programming
    Replies: 0
    Last Post: 04-06-2010, 10:12 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums