Hi:
I have an access front end that links to tables in A MySQL database. But every time open my access front end, and try to connect to one of the linked tables from a button click event on a form, I get a runtime error '-2147467259 (80004005): ODBC--connection to 'MySQL ODBC 5.1 Driverlocalhost' failed. I Would have to click on one of the linked tables directly to bring up the: "MySQL Connector/ODBC Data Source Configuration" window, and enter my login info. After this, I am able to connect to these tables from these button click events. Instead of giving me the runtime error message how can I instead make the MySQL connector screen appear when I click my command buttons, and enter my login credentials from there. Thanks in advance.
I have an access front end that links to tables in A MySQL database. But every time open my access front end, and try to connect to one of the linked tables from a button click event on a form, I get a runtime error '-2147467259 (80004005): ODBC--connection to 'MySQL ODBC 5.1 Driverlocalhost' failed. I Would have to click on one of the linked tables directly to bring up the: "MySQL Connector/ODBC Data Source Configuration" window, and enter my login info. After this, I am able to connect to these tables from these button click events. Instead of giving me the runtime error message how can I instead make the MySQL connector screen appear when I click my command buttons, and enter my login credentials from there. Thanks in advance.
