I have a report that I export from Access to Excel. Before I do that I need to generate a query in Access that have a connection with an Informix database. When I ask to run the query a pop up ask for login/password.
How can I automate this?
Or how can I create a string connection so when I run the query the connection with the server is already stabilish?
I tried this:
Private Sub testConection()
Dim cn As New ADODB.Connection