MS Access connect to mysql backend automatically

I have an MS Access 2003 frontend and mySQL backend.

I would like to automatically connect to MySQL when the MDB is opened for the first time, eg when the Main Menu form of Access is displayed.

However开发者_如何学JAVA I have no idea and I keep getting the "annoying" MySQL "Connector ODBC" pop up box.

This happens when I go into a form in Access which has obviously fields "connected" to MySQL.

Any ideas how to do this?

Thanks !!!!

There should be a checkbox called something like 'Remember password' when you create the linked tables using ODBC. Try recreating the links to the tables and making sure this is ticked. Access should start up knowing how to access the tables as if they were native.

(Works in Access 97)