Use MySQL ODBC Connector with MS Access
MySQL Connector/ODBC (also known as MyODBC) allows you to connect to a MySQL database server using the ODBC database API on all Microsoft Windows and most Unix platforms, including through such applications and programming environments such as Microsoft Access, Microsoft Excel, and Borland Delphi.
First we must install on windows the mysql Connector ODBC which is a standardized database driver for Windows, Linux, Mac OS X, and Unix platforms.
We can download it on dev.mysql.com web site … check windows link
http://www.youtube.com/watch?v=Wx910ABixzU