Hello all.
I have a program that run's queries in Access on tables that are linked to an Informix database via ODBC. If I close the Access database then re-open and run the program I get a screen that shows the server name, database name, and asks for the userID and Password of the informix database.
I would like to place a connection string in my On_Click event to eliminate this pop-up, or somehow tell access to always keep this connection open if it is open.
Can anyone help?
Thanks.
I have a program that run's queries in Access on tables that are linked to an Informix database via ODBC. If I close the Access database then re-open and run the program I get a screen that shows the server name, database name, and asks for the userID and Password of the informix database.
I would like to place a connection string in my On_Click event to eliminate this pop-up, or somehow tell access to always keep this connection open if it is open.
Can anyone help?
Thanks.