Web Hosting Plus Logo

Web Hosting How-To Articles, Help and Information at Web Hosting Plus

Can I use Access Databases on my web hosting package?

Back to Help Main Page

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://msdn.microsoft.com/en-us/data/aa937730.aspx

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

This is in reply to:

Can I use Access Databases on my web hosting package?

Web Hosting Plus Help Main Page