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: check permissions or privileges given to user
Next Topic: rights of a user on a different schema dissapeare
Goto Forum:

Current Time: Tue Aug 22 02:23:52 CDT 2017

Total time taken to generate the page: 0.01498 seconds