Hello all... I work with a backend server that is connected via ODBC. We use an Access front end and an Oracle backend. I have a need to refresh the links to all backend tables since the login credentials will be changing often. I'd like to have each application access a common area on the network (whenever a user runs it) where it can pick up the User ID and Password that are currently in effect. This should ensure that the app will log in to the backend data and hopefully the process will be invisible to the end user. I can set that part up. The problem is that I'm not sure how to go about using VBA to programmatically change the User ID and Password once I have the correct variables loaded with the User ID and Password. Is there a special object library or something like that that I should reference in order to change the properties of the ODBC connection? If so, what library would that be? Any help is greatly appreciated.
Thanks in advance...
Glenn