Could anyone advise me on a curious problem.
I have set up ODBC connection from my Access database to a remote MySQL database. This works fine and I have linked the tables OK.
However, when I close Access and then reopen and try to view a form query, the ODBC Connector form appears and, whilst is is set for the correct database, it defaults to the root user and password, not the one I entered when making the link in the first place.
Is there a way to set the connector to the user and password originally entered?
I have set up ODBC connection from my Access database to a remote MySQL database. This works fine and I have linked the tables OK.
However, when I close Access and then reopen and try to view a form query, the ODBC Connector form appears and, whilst is is set for the correct database, it defaults to the root user and password, not the one I entered when making the link in the first place.
Is there a way to set the connector to the user and password originally entered?