I am linking to an ORACLE table and to do this I have set-up an ODBC link which is secured by an ID and Password. I am doing this so that I do not have to duplicate the data from another application into my MSAccess application. The issue I am having is that when I go to run my forms and/or queries, that use this linked table, it asks me for the ID and Password. Is there a way to automatically make the ODBC connection when my MSAccess application starts. I do not want the user to have to remember another ID/Password. Thanks for any advise.
Linking to tables outside of MSAccess
- Thread starter JRG0620
- Start date
- Local time
- Yesterday, 22:01
- Joined
- Aug 30, 2003
- Messages
- 36,272
I haven't used Oracle, but when linking to SQL Server tables there is an option in that process that asks if you want to save the password. It's a checkbox on the form where you choose the tables to link. You might try relinking the tables with that option checked, if available.
