You can use two approaches to connection to MySQL Database.

1.) MyODBC 3.51 Local database (using ODBC)
Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3;

2.) OLE DB, OleDbConnection (.NET)
Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword;

You can also try some open source MySQL Drivers but the above 2 are really reliable.

You can also read an article on using MS Access with ASP.NET here
You can also download the sample application by simply registeting.