ODBC call failed

Very weird problem. We built a new server downgrading from the full SQL to MySQL. We have an access database where we link tables from that SQL database. We created the DSN and all works fine for a day. The next day, we get ODBC–call failed error so I re-link tables and all is fine for a day. The next day I get the ODBC call failed error. I’m ok with re-linking the tables every day but a few other people use the database too and they aren’t ok with it. Does anyone know what might cause this problem?

Thanks