The solution to this problem is to use the Microsoft Jet OLE DB Provider in order to establish connection to your Access database.

This error is generated by MySQL server because you don't have privileges to connect to the server from your host. Please contact your database administrator to resolve this problem.

Try to reinstall the Microsoft Data Access Components (MDAC) 2.8. You can download it from the page http://www.microsoft.com/downloads/search.aspx?displaylang=en

EMS Data Pump for MySQL is a powerful utility for converting databases and importing table data from an ADO-compatible source (e.g. MS Access or any other database with ADO support) to MySQL databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target MySQL database and select tables for import. Data conversion becomes as easy as possible with EMS Data Pump for MySQL!

First of all you must have an opportunity to connect to some local or remote MySQL server. Besides you need your computer to satisfy the system requirements of EMS Data Pump for MySQL.

This is a limitation of the trial version which converts only 10% of all records. With a registered version all the records are processed.