I have an Access application with links to MySQL tables. Every time I start the application I get error messages indicating inability to read the linked tables. When I have relinked everything works fine, but eventually I log off the application and get the same problem the next time I open the application.
Exact error message is: ODBC -- Connection to "GreenSheet" failed
When I defined this connection using ODBC Datasource Administrator, the test works fine.
it doesn't solve why access is disconnecting from MySQL (perhaps because you are committing the crime of not using a Micorsoft back end), but as a work around you could programaticaly check if the tables are linked, and if not relink through code prior to using the tables for any other purpose.