Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Microsoft Access to Oracle Interface - how not to prompt for password

Re: Microsoft Access to Oracle Interface - how not to prompt for password

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 22 Jan 2005 17:49:22 -0800
Message-ID: <1106444962.907449.252330@z14g2000cwz.googlegroups.com>


snip

> Now when I go Access and export the access table into oracle it
> again asks me for the password which I had already specified in
> data source. I know it is for security reasons, but is there any
option
> to set the password just once.

I think it's pretty easy to write a little vb code to automate that part why don't you try that approach? Received on Sat Jan 22 2005 - 19:49:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US