Hi

I have a scenario in which I have a front end Access application and it is connecting to an Oracle backend.

There are linked tables in the Access frontend which is linked to oracle through ODBC-DSN. Its connecting and everything is working fine.

But the problem is everytime I start my application I am asked for the password to connect. I dont want it to ask for password everytime. Is there anything that I need to do in the DSN file to save my password, so that it does not ask for it everytime.

Any help in this is appreciated.

Thanks a lot

Robert