MS access 97 to Oracle db connection

[manutektips]

Hi,
I have an ms access 97 application which has linked tables to Oracle database. This ms access 97 application should run at a batch job in the night. Whenever it runs, when it tries to connect to the oracle database, the application prompts for the password. Though I have stored the userid and password in ms access table to pick up by the code, still it prompts for the password to enter when i run the application. Could any one suggest how to supress the password prompt

 

[PHV]

When linking the tables have you ticked the remember password checkbox ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886