Entering Oracle passwords

[frumforum]

Hello all,
I'm running an Access app that gets data from an Oracle db. My app needs to run overnight, but I have problems since it asks for the Oracle pwd. Is there a way to automatically enter this pwd when the prompt comes up?

Thanks.


--- THIS SHOULD BE THE LAST ACT OF TERROR ---

[Hack]

I put my passwords in my Oracle connect string, and none of my users ever even since a login dialog box.

[frumforum]

I'm actually doing this in Access and VBA; I'm not sure how to do a connection string there.

Thanks again.