[ASP3.02] 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

[ASP3.01] Can I use ASP Components such as CDONTS, ADONTS, CDO and others on my package?

These components are available, but do require ASP.net. Therefore you must be using a Windows...

[ASP3.05] What is the server path?

The path to your website is partially determined by your domain name, but is in the following...

[ASP3.03] How can I change the file name extension of my index page?

It is possible to name your default index page something other than index.html, index.cgi,...

[ASP3.04] Common server software requirements

All standard Apache modules are installed on the web servers, including mod_rewrite. In addition,...

[ASP3.06] Is ASP.NET 3.5 available? Why does my script report only version 2?

This applies to Windows hosting accounts only. ASP.NET 3.5 is not a stand alone framework like...