Is it possible to connect an MS ACCESS project to a MySQL database?

Question

I'm trying to set a small billing system using MS Access as a platform. I have a MySQL database setup through my web hosting company (Yahoo). Can anyone provide some pointers as to how to do it -if at all possible-?

Answer 1

Yes, but you well need to download MySQL's ODBC driver to do so. Once you have it downloaded and installed you will then be able to access MySQL tables using Microsoft Access.



Here is a link to the ODBC Driver:

http://dev.mysql.com/downloads/connector/odbc/3.51.html



You will have to go to Start > Control Panel > Administrative Tools > Data Sources to configure it. Once you get that setup and connecting properly to your MySQL database, then go to Access. Once in Access, go to File > Get External Data > Link Tables. When the windows opens, choose Files of Type: "ODBC Databases()" and then select the one you just configured.



Hope this helps.

Answer 2

certain you'll might want to acquire and installation the MySql ODBC using rigidity. After installation set up your Mysql connection by creating use of going to My information resources settle on on MYSql ODBC then enter your server information login and such. contained in the adventure that your MYSql server is on a hosted gadget and by no ability interior of attain make sue your MySql db will settle for connections out of your ip or set it as a wild card using % reliable fulfillment.

Answer 3

Yes you will need to download and install the MySql ODBC driver. After installing set up your Mysql connection by going to My Data sources select MYSql ODBC then input your server info login and such. If your MYSql server is on a hosted machine and not local make sue your MySql db will accept connections from your ip or set it as a wild card using % good luck.