Bypass username/password prompt when updating Oracle table via ODB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, all. I have been doing a huge amount of research on this for the past
couple of days. So far I have been able to query my Oracle database without
needing to dynamically provide the username/password each time by using
pass-through queries. However, it does not seem to work when I want to
update or insert records. Even when I provide the connection string with the
un/pwd hardcoded, it still prompts me for the values. I cannot use a
pass-through since the data needs to come from the Access db, so I am using a
traditional Access append query and then through VBA attempting to execute it
and provide the necessary Oracle credentials. As I mentioned previously, it
prompts me.

Any insight into what I am doing wrong? Can this even be done with Access?

Many thanks.

Christian
 
Back
Top