[OTH1.01] Can I use Access Databases on my package with Hosting cPanel?

We only offer MySQL databases on our packages. Microsoft Access Databases are not fully ODBC compliant as standard and as such can not be used in their native form on the packages we offer. However it is possible to convert Access Databases into a MySQL format and then use converted databases on our packages.

There is an ODBC driver available for free that you can use to interface with MySQL which is called MyODBC. Go to http://www.mysql.com/downloads/api-myodbc.html for the latest version of the MySQL ODBC Driver.

To setup MS Access to work with MySQL using MyODBC (3.51) :

If you are using MS Access 2000, it may be necessary to install the newest (version 2.6 or above) Microsoft MDAC (Microsoft Data Access Components) from http://www.microsoft.com/data/

Install the latest version of MySQL from http://www.mysql.com/downloads/index.html/

Install the latest version of MyODBC 3.51 or MyODBC

For all Access versions, you should enable the MyODBC (3.51) option flag Return matching rows

Now start working with Access as the front-end for MySQL server through MyODBC or MyODBC 3.51

Was this answer helpful?

 Print this Article

Also Read

[OTH1.02] What are valid connection strings on the Windows platform?

MySQL:Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase;User=myUsername;...