You're saying when your program accesses the Oracle database, the user is prompted for a login name and pw??? That doesn't seem right.

You can pass a login name/pw to the Oracle DB in your connection string (assuming you are using ADO), as follows:

cnnDB.Open "Provider=MSDAORA.1;User ID=YourID;password=YourPW;Data Source=YourSource;"

This way the user should never be prompted to login when they access a database of any kind...it should all happen transparently through the code.