Access & ODBC

[Jean Marie]

Hello,

I've got an application access with à link on oracle File. When I want to
display a form based upon one of this file, I've got a dialog box which
appears and requires à password to set the connection with the oracle files.
Is it possible to type the password just once to avoid this dialog box ??

Thanks for your help.

Regards.

 

[Joe Fallon]

Yes.
Delete the linked Oracle table.
Then re-link it.
When you get to the list of tables, stop and check the Save Password box.
Then pick the table(s) to link.