SEO

#1 (**permalink**) 02-24-2008, 10:27 AM

I am using Microsoft Access 2000 and Oracle9i. I have set ODBC
Datasource. When I configured this datasource, I supplied Service Name,
User ID and Password.

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 looked into ODBC help which came with Oracle ODBC 9.2.0.6 driver
installation, but could not find anything.

Thanks,

Prem

#2 (**permalink**) 02-24-2008, 10:27 AM

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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