How to Link Oracle database in MS Access Programmatically
We had an application written in MS Access and has using Oracle database as back-end. Tables are linked manually using the ODBC link. Everytime we run the MS Access form it will always prompt for ODBC connection window that asks for username and password.
Is there any way to programmatically (code) do it so as it wont prompt anymore for ODBC username and password?
Thanks.