Home » RDBMS Server » Security » Automatic Log on to Oracle from Access
icon5.gif  Automatic Log on to Oracle from Access [message #196276] Wed, 04 October 2006 13:28 Go to next message
Messages: 1
Registered: October 2006
Location: Mississippi
Junior Member
I have a Report Generator written in MSAccess which runs each morning. This Report Generator runs on Windows XP which is located in a secured server room at a branch location. It pulls information from a Oracle 8 DB. The client was installed as the typical setup. I wish to hardcode the user ID and password so I can run the daily update as a Scheduled Task from Windows. What is the best way to store the ID and Password.

Re: Automatic Log on to Oracle from Access [message #201480 is a reply to message #196276] Sat, 04 November 2006 14:53 Go to previous message
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Not really a question about Oracle, as much as a question about Access, right?

You can probably hardcode something into VB.Net or whatever Access' scripting language are called.

Have fun!

Previous Topic: How can the user SYS or SYSTEM to find out a user's password (merged)
Next Topic: not able to access Oracle Advance Securty
Goto Forum:

Current Time: Fri Dec 09 04:27:05 CST 2022