Automating ODBC User ID and Password

[RonMcNatt]

I am using Microsoft Access 2002 as a front end to conenct to our Oracle Databse through ODBC drivers.

When I run a query, I am prompted for the user id and password to access the Oracle Database. Is there any way I can script a response for this info, maybe through a module? I have an example of some VBA code that does this, but it's not very clear how it is set up.

I have created an automatic task to run the query in the early morning hours, but no one will be there to enter in the username and password.

Thanks in advance for your hellp.

Ron

 

[cheerio]

If you do this as a pass through query you can choose to store the login and password in the connection string.

If you do this you should use Access security to password the Access database otherwise anyone with access to your Access file can read your ORACLE login/password.

Are you sure that Oracle cannot have scheduled tasks defined at the server end as they would run even if your own PC was down?

Ken

 

[RonMcNatt]

Thanks for the suggestion. It seems to be working just fine. In regards to scheduling the event on Oracle, I ending up pulling down some data from Oracle and perform additional processing on the local machine. Thanks again for the help.

Ron