We're using MSSQL, not MySQL..
If you want to work with MySQL, then you'll need the MySQL drivers (MyODBC)
http://www.mysql.com/products/connector/odbc/
http://dev.mysql.com/doc/refman/5.0/en/odbc-connector.html
Im not guaranteeing that it will work with access, but if you set it up as an ODBC...