An Access Front-End to MySQL

(Page 1 of 4 )

Using ODBC, Access can connect with a MySQL database. A proprietary front-end to an open-source database? Microsoft and MySQL? Irreconcilable differences would seem to condemn such a union to a rapid divorce. Read on to see how, despite expectations to the contrary, this marriage can work.

Why do it?

Even though I have been running a dual-boot Windows/Linux machine for a number of years, I still enjoy being able to see my Windows partition from Linux. So, as you might imagine, the voyeuristic pleasure of seeing a MySQL database through the eyes of Access was irresistible. This was all the motivation I needed to attempt to use Access as a front-end for MySQL. However, for the more practically minded, there are many good reasons for doing this; let me enumerate a few of them.

First, MySQL does not come with a graphical interface. The ability to open multiple windows of different tables and queries is a real advantage especially to those who are not used to working from the command line.

How do you go about building a report from a MySQL database? Say what you like about Access, but there is no denying that its reporting capabilities are excellent.

While it has its limitations, Access’ “Query by Example” window for creating queries can be very useful, especially for those who don’t have a strong grasp of SQL.

Finally, maintaining a website is expensive. With a dynamic, database-driven site, clients who are competent computer users can keep their costs down by maintaining the database themselves. In this instance, using Access as an interface to an online database is an attractive option because, for those familiar with Access, there will be no learning curve. Making changes to records in a MySQL database will be no different from doing so in Access.

In sum, using Access in this way might appeal to website administrators, developers and power users.

Next: Preliminary Steps >>
 

More Microsoft Access Articles
More By Peter Lavin

Comments On: An Access Front-End to MySQL

· One other thing worth mentioning is that if you use pass thru queries you can use...    · Thanks for the article. I also found that an effective way to transfer a single...    ·     ·     · Question?? I am trying to add records to a Mysql table using access. The primary...    · RTFM ;-) *kidding*Have one more dummy column with TIMESTAMP as the data type,...    · I have Access set up as a front end to a MySQL database. I have a form in Access...    · I have Access set up as a front end to a MySQL database. I have a continuous...    · The problem was fixed. When I created the column with TIMESTAMP as the data...   >>> Post your comment now!